<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Alvaro Herrera escreveu:
<blockquote cite="mid:20071004200537(dot)GB28896(at)alvh(dot)no-ip(dot)org" type="cite">
<pre wrap="">Mike Ginsburg wrote:
</pre>
<blockquote type="cite">
<pre wrap="">Hello,
I am working on a personnel registry that has upwards of 50,000
registrants. Currently I am working on an export module that will create a
CSV from multiple tables. I have managed to keep the script (PHP) under
the memory limit when creating and inserting the CSV into the database.
The problem comes when I try to query for the data and export it. Memory
limit is a major concern, but the query for one row returns a result set
too large and PHP fails.
</pre>
</blockquote>
<pre wrap=""><!---->
One row? Wow, I didn't know PHP was that broken.
Try declaring a cursor and fetching a few rows at a time.</pre>
</blockquote>
PHP is just respecting memory_limit when retrieving data. <br>
In this case, a single row is about 30M, a lot more than the limit of
16M.<br>
I think cursors wouldn´t help anyway.<br>
<br>
[]´s,<br>
ACV<br>
<br>
</body>
</html>