+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23)
+--- Thread: Code stops with queries that take long execution time (/showthread.php?tid=17526)
Code stops with queries that take long execution time - El Forum - 04-07-2009
[eluser]ikhnaton2[/eluser]
I'm just trying to execute simple query using oci driver. The simple query is counting all rows in table (select count(*) from table_name). The query normaly should take almost 30 seconds but when I execute it through CodeIgniter, it doesn't return anything and page doesn't return anything. Is there connection timeout in the OCI driver or something? Please advice as I stuck with this and if it doesn't work, I have to redesign the application from the beginning with other framework.
Code stops with queries that take long execution time - El Forum - 04-07-2009
[eluser]CroNiX[/eluser]
Check your webserver logs. I bet you are hitting your max execution time for php which by default is 30 seconds unless you have changed it.
Code stops with queries that take long execution time - El Forum - 04-09-2009
[eluser]ikhnaton2[/eluser]
Thanks a lot Grad Student. That was the issue, I changed it in php.ini