Hmm
I'm guessing my stats arent too good, lots of full table scans, but this is to be expected, my users can query any table by any column, and I cant index all column combinations
Variable_name Value
Select_full_join 0
Select_full_range_join 24
Select_range 145321
Select_range_check 0
Select_scan 29402 Sort_Scan 15360
Key_reads 37811885
and on the other big db..
Variable_name Value
Select_full_join 535
Select_full_range_join 0
Select_range 1098
Select_range_check 0
Select_scan 10443 Sort_Scan 2464
Key_reads 20282002
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
