Re: PHP and MySQL and resouce limits

John Hinton wrote:

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.... Thanks, John Hinton

Are you sure your query is correct? This happens to me sometimes if the query is rather crazy... Matt Darby