Re: At Performance Limit for 2 GB RAM?
The 2 primary key are different
(`metadata_id`,`stn_id`,`dich_value`)
(stn_id, metadata_id, dich_value)
The 2nd is able to give you results very fast becasue it is sorted by the stn_id which is able to helps you get all the rows with stn_id = 2500. This should remove the using where in your explain.
Having this primary key may be even better
(stn_id, dich_value, etadata_id)
This will help the "group by dich_value" in your query. This may help remove the using temporary and using filesort in the explain.
Try it and see the difference in the explain result.
Subject
Views
Written By
Posted
7831
July 20, 2005 09:42AM
3446
July 20, 2005 05:45PM
3294
July 22, 2005 01:33PM
3209
July 22, 2005 02:06PM
3608
July 22, 2005 02:13PM
2827
July 25, 2005 01:40PM
3024
July 26, 2005 03:47PM
2856
July 26, 2005 06:55PM
2961
July 26, 2005 07:06PM
3008
July 27, 2005 09:46AM
2868
July 30, 2005 11:44AM
3472
August 01, 2005 11:18AM
3416
August 04, 2005 07:17PM
3914
August 08, 2005 09:08AM
Re: At Performance Limit for 2 GB RAM?
2940
August 02, 2005 12:59AM
3208
August 08, 2005 09:26AM
2814
August 09, 2005 07:57AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.