Submitted by Kiran on Tue, 01/12/2010 - 14:27
For sorting an index and data according to an index, use
myisamchk --sort-index --sort-records=1
(assuming that you want to sort on index 1).
(assuming that you want to sort on index 1).
This is the best way to make queries faster if you have a unique index from which you want to read all rows in order according to the index.
However, the first time you sort a large table this way, it may take a long time.
Bookmark/Search this post with:
»
- Kiran's blog
- 693 reads
Post new comment