Re: major performance disparities with mysql/php - SOLVED

2002-03-21 Thread Henry Hank
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 temp 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 instea

major performance disparities with mysql/php

2002-03-14 Thread Henry Hank
Hello Again - I'm posting this again, since it still is an issue that I can not resolve - please help! I've recently installed mySQL on a RH7.2 box without any problems - it runs great. I've been testing some long running queries (full table scans, etc) under different scenarios, and get wil