Re: Seemingly Simple Query Takes Much Too Long
What I see from the above is that you might have changed the order of the columns in the table definition. But I still see PRIMARY KEY (`uid`,`serv_id`).
This is probably worse than before since the primary key does not match the order in the table. So please try to change that to PRIMARY KEY (`serv_id`,`uid`).
If this still does not help, then please repeat your question in our 'Performance' forum. The people there are more knowlegable to these kinds of problems. And your problem is most probable unrelated to MyISAM. If the people in the 'Performance' forum think that I'm wrong, they can explain why and then I might be able to provide better advice.
Subject
Views
Written By
Posted
8299
May 27, 2005 02:56PM
3838
May 30, 2005 01:59AM
3481
June 01, 2005 11:08AM
Re: Seemingly Simple Query Takes Much Too Long
3268
June 02, 2005 01:58AM
2845
June 02, 2005 10:24AM
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.