Code stops with queries that take long execution time

[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.

[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.

[eluser]ikhnaton2[/eluser]
Thanks a lot Grad Student. That was the issue, I changed it in php.ini