Re: [PHP-DB] DB and mssql

2004-04-14 Thread Matt Matijevich
[snip] 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

Re: [PHP-DB] DB and mssql

2004-04-14 Thread Robert Twitty
On Wed, 14 Apr 2004, Matt Matijevich wrote: [snip] [/snip] Thanks for the response. If I was hitting the memory limit, wouldn't php throw me some kind of error? Or would it just abort? It's normally the job of the extesion to report the error. But, I am not completely sure because I have

[PHP-DB] DB and mssql

2004-04-13 Thread Matt Matijevich
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

Re: [PHP-DB] DB and mssql

2004-04-13 Thread Robert Twitty
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