I have a myisam database on a little Redhat 8 Celeron P3-866 with less than 256MB of ram. (Schema attached). While response for single table queries is excellent. (Double table queries are also mostly good.) More real world (ie complex) queries are glacial in their execution.
My suspicion is that the either I have the database "tuned" wrong, (which one of these buttons do I push and how much) or the machine is just terribly underpowered. (I could try this on a dual P3-1ghz server with 2gb ram, but the microsofters will whine.) The tuning parameters are set at defaults... (not touched since rpm install). 4.0.18 database version. The schema isn't special, but the file is too big for the mail system... -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]