note 24363 rejected from function.mssql-query by maxim
| From: | maxim@php.net | Date: | Wed, 14 Aug 2002 16:59:43 +0000 |
| Subject: | note 24363 rejected from function.mssql-query by maxim | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-35006@lists.php.net to get a copy of this message | ||
I have a problem when my MSSQL stored pocedure runs for a long time and/or (??) returns a very large
amount of data.
The stored procedure runs many encryption/decryption on a large DB, making joins, an so on. Inside
the SQL Query analyser, it can take some hours to run. When executing the SP from PHP4, it seems the
query is executed (I can see it in SQL management), but the resultset is never kept by the php
script. When running a smaller (and faster) version of the SP, everything goes well.
Any idea? Is there a time or capacity limit to php?
I use set_time_limit(0);
config:
Win2000 server and MSSQL server
Apache, Linux red hat 7.1, FreeTDS 7 and PH4