On Wed, July 20, 2005 5:22 pm, John Hinton said: > I don't get it... I have been upping my memory limit for PHP. 32megs > now... and am making calls to a database on a different server. I see > the loads run up on the other server as it cruches the numbers.. and PHP > is in the process of creating a single little page with about 40 numbers > on it, from these returns. Now, I do know I'm crunching a LOT of data in > this instance, but it seems like MySQL is doing the work and that PHP > shouldn't be hitting 32 my 32meg wall. Running the same query on a > smaller dataset doesn't hit this limit, so I know it's not a function of > the PHP code itself. > > So, I must be missing something, why is PHP somehow tied to the work > MySQL is doing? As in memory usage.... seems that MySQL should be simply > sending PHP the returns on its commands... hmmmmm....
Print out the query you are sending off to MySQL. Inspect it carefully. Use the mysql monitor to run it. Can MySQL, without PHP in the picture, run that query in practical time/memory constraints? How many rows does it actually return? How much data in each row? Dollars to doughnuts sez your query isn't doing what you think it's doing, and it's returning *WAY* more rows than you think, and poor PHP is trying to process them all... -- Like Music? http://l-i-e.com/artists.htm -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
