[PHP-DB] Re: major performance disparities with mysql/php - SOLVED

2002-03-21 Thread Henry Hank
Nevermind.. I found the problem. My production server is running mysql 3.22.29, and I needed to use a SET SQL_BIG_TABLES=1 in many places to prevent a full table condition. The new server is running 3.23, and once I removed the SQL_BIG_TABLES=1 from the script (and allowed mysql to use memory

[PHP-DB] Re: major performance disparities with mysql/php

2002-03-21 Thread John Lim
Hi Henry. I have a suggestion. Run in a seperate window top d 1 with php running or mysql client and compare what happens. I presume that X-windows and similar mem/cpu hogs are disabled. Do post your results please. This should be interesting. Regards, John Henry Hank [EMAIL PROTECTED] wrote