note 24363 added to function.mssql-query

From: Date: Wed, 14 Aug 2002 09:44:32 +0000
Subject: note 24363 added to function.mssql-query
Groups: php.notes 
Request: Send a blank email to php-notes+get-34991@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 -- http://www.php.net/manual/en/function.mssql-query.php http://master.php.net/manage/user-notes.php?action=edit+24363 http://master.php.net/manage/user-notes.php?action=delete+24363 http://master.php.net/manage/user-notes.php?action=reject+24363

« previous php.notes (#34991) next »