Gleb Paharenko wrote:
Hello.


I get 142k rows back in just over 4 seconds.


It means that on the server side query works, so the problem
probably is in PHP.

Good call. I did some testing, and sure enough, the mysql_query() is successful. The failure comes in trying to retrieve the rows using

while($row = mysql_fetch_assoc($queryID))
{
        $arrResults[] = $row;
}

So, it would seem that I need to take this issue to a different list.

Isn't the PHP level logging high enough? Increase the memory_limit
variable in you php.ini.

I did try to do an ini_set() on the memory_limit variable, but it appears that my host does not have this enabled.

Thanks for the tips.

-Erich-

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to