When I make a complex query to a table with 500,000 rows via PHP, my web browser thinks for a minute and then stops the execution of the script with no error messages at all.

I have set the max_execution_time to 400 and called error_reporting(E_ALL) with the same results. I'm using PHP 4.3.1 and Oracle 8i with Solaris 5.8.

I'm using the ORA functions because my sysadmin has not enabled the OCI functions. Oh, I'm also calling ora_commiton($conn) at the start of every script.

What's really strange is that I can often hit Refresh after a halt like this, and the script will then work perfectly. I don't understand why that is because I examine the $_REQUEST and $_SESSION variables each time, and nothing is changing.

Any advice would be greatly appreciated. I normaly use MySQL or SQL Server, so I'm assuming my Oracle ignorance is to blame.

Thanks!
Matt

_________________________________________________________________
Check out MSN PC Safety & Security to help ensure your PC is protected and safe. http://specials.msn.com/msn/security.asp


--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Reply via email to