Re: Sudden drop in performance on MyISAM DB
Good point.
Or even: ALTER TABLE message ADD INDEX(publisher_id, created_on);
to get ordering "for free" too.
Hope this helps,
Jørgen Løland
Software Engineer, MySQL, Oracle
jorgenloland.blogspot.com
Subject
Views
Written By
Posted
2615
October 15, 2012 07:46AM
1050
October 16, 2012 06:29AM
968
October 16, 2012 07:56AM
858
October 17, 2012 01:29AM
883
October 16, 2012 07:40PM
Re: Sudden drop in performance on MyISAM DB
837
October 17, 2012 01:19AM
810
October 17, 2012 01:47AM
921
October 17, 2012 03:21AM
965
October 17, 2012 04:28AM
896
October 17, 2012 10:38AM
879
October 17, 2012 09:41PM
833
October 18, 2012 12:34PM
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.