On Thu, Oct 27, 2011 at 10:04 PM,  <p...@umpquanet.com> wrote:
> Something more fundamental is going on.
> Here is simpler code which still reproduces the problem.
> I get:
> PHP Fatal error:  Allowed memory size of 134217728 bytes exhausted (tried to 
> allocate 20 bytes) in xx3.php on line 26
> What's up with that?

Hmm, okay, I haven't worked with such huge datasets in MySQL and PHP
before, so now I'm speculating here.

If the dataset is so huge that it's eating up all your memory, perhaps
you need to cycle through the data base using limits, and process it
in chunks, and release each dataset as you're done processing it. I
know I've had to do that with Oracle databases before that were
storing 100's of millions of records. It's rather like pagination for
displaying data, only in this case you can have much much higher
chunks than a displayed page.

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

Reply via email to