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
the memory_limit parameter. So, try increasing it and see if it solves
the
problem.

-- bob
[/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?

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

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 never hit the limit.

-- bob

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

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 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 1 - 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