Re: Performance problem when table gets bigger
Posted by:
ICI MASA
Date: July 12, 2005 09:06AM
Hi there, I hope you can read this, not the most formated text i have seen, if not I try to format it somehow just let me know
id select_type table type possible_keys key key_len ref rows Extra
1 PRIMARY tbScanList ref DID,tbDevicetbScanList,TID,tbScanTemplatetbScanList DID 5 const 1 "Using where; Using temporary; Using filesort"
1 PRIMARY <derived2> ALL 25 (null)
1 PRIMARY tbPoint eq_ref PRIMARY,NID,tbScanTemplatetbPoint,TID PRIMARY 4 tmpTb.NID 1 Using where
2 DERIVED <derived3> ALL 25 Using where
2 DERIVED v1 eq_ref PRIMARY,NID,tbPointtbValue,VID PRIMARY 4 v2.LastUpdate 1 Using where
3 DERIVED tbValue ALL 2974862 "Using temporary; Using filesort"
Regards
Martin