Re: At Performance Limit for 2 GB RAM?
KimSeong-
Initial results look promising on this index change. I tried it on the 20 million rows and got sub 0.1s performance. I will rebuild the indexes on the 200 million rows and do some more complete testing. Then I will post my findings. As you noted the filesort and temporary went away. (I think I had a different view of how the optimizer was solving the query, but when you brought up this change I think it final has dawned on me what the optimizer is trying to do.)
Thanks again,
Nick
Subject
Views
Written By
Posted
7675
July 20, 2005 09:42AM
3369
July 20, 2005 05:45PM
3231
July 22, 2005 01:33PM
3156
July 22, 2005 02:06PM
3548
July 22, 2005 02:13PM
2774
July 25, 2005 01:40PM
2958
July 26, 2005 03:47PM
2810
July 26, 2005 06:55PM
2912
July 26, 2005 07:06PM
2945
July 27, 2005 09:46AM
2805
July 30, 2005 11:44AM
3399
August 01, 2005 11:18AM
3364
August 04, 2005 07:17PM
3861
August 08, 2005 09:08AM
2880
August 02, 2005 12:59AM
Re: At Performance Limit for 2 GB RAM?
3155
August 08, 2005 09:26AM
2764
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.