Re: Re: mysql and unbuffered queries
| From: | Sascha Schumann | Date: | Mon, 07 May 2001 08:53:23 +0000 |
| Subject: | Re: Re: mysql and unbuffered queries | ||
| References: | 1 | Groups: | php.dev |
| Request: | Send a blank email to php-dev+get-54193@lists.php.net to get a copy of this message | ||
> Hmm..this seems to be an undocumented function. What is the use of it?
> Benefits over using mysql_query() for example? Where/when it _can't_ be used?
Apparently, the mysql client library loads the complete
result set into the process space of the client.
For example, bugstats.php used to bloat httpd processes up to
20MB, because that script loads the complete bug database
into memory. After switching to mysql_unbuffered_query() no
significant increase in RAM usage was noticed.
- Sascha Experience IRCG
http://schumann.cx/ http://schumann.cx/ircg