Hi Matt Before sending the result set, the mssql extension stores the entire result set into memory. However, PHP limits the amount of memory that can be allocated by a script to 8MB. So, the query will fail if the result set is larger than 8MB. You can change this value in php.ini with the memory_limit parameter. So, try increasing it and see if it solves the problem. -- bob On Tue, 13 Apr 2004, Matt Matijevich wrote: > I am using PEAR::DB on linux, php 4.3.2, with freetds to access a sql > server database. I am trying to get more information on the problem, > but everyonece in a while, it seems random, php will stop executing when > I use the query method, php stops executing. I dont get an error, php > just stops running. I can echo out things before the query call but not > after. > > The query that is running can return large result sets,on the high end > it will return 10000 - 15000 rows. > > I am am sql server novice so I am not sure where to start looking to > see if the problem is db server side. > > I am just wondering if anyone has had this kind of problem before. I > am not sure if it is something going on with PEAR::DB or if something is > happening with the native php calls to sql server. > > I have not tried to do the query without using pear::db, but I am going > to try that to see if I can get the script to error out that way. > > Thanks in advance. > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
