On Tue, Jun 10, 2003 at 10:18:30AM +0100, Tim Bunce wrote: > On Mon, Jun 09, 2003 at 04:50:18PM -0500, Stephen Clouse wrote: > > -----BEGIN PGP SIGNED MESSAGE----- > > Hash: SHA1 > > > > On Mon, Jun 09, 2003 at 02:33:30PM -0700, Jamin Roth wrote: > > > OK running dmesg shows that the OS is out of memory. When $sth->execute is > > > run are all of the records returned? That would take out a ton of memory. > > > > It would not surprise me at all if MySQL was stupid enough to attempt this. > > It's not a question of stupidity, it's a very valid design choice > that's part of MySQL's generally excellent performance. > > (Stupidity would be not reading the documentation ;-)
And of course doing so will tell you how you can turn it off. Which if you know you have a large dataset being returned, makes a lot of sense. Graham.
