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]

Reply via email to