>>>> 2012/06/13 10:06 -0500, mos >>>>
You may want to look into Handler. I've used it often when I needed to traverse very large
MyISAM tables. Handler requires no physical sorting of the table because it traverses the
table using an index. It also ignores any locks on the table (which you may or may not
like), but the Handler will start traversing the table immediately. It will solve
problems 1,3 ,4 but not #2 because traversing a large table with an index will be slower
than if the table was already sorted. One nice thing about the Handler is it uses
virtually no additional memory regardless of table size and very little disk activity
because there is no sorting. You can run it any time and it won't degrade other MySQL
processes. I don't think Handler will join tables together; I have used it only to
traverse a single table.
I saw HANDLER written up, and from MySQL tryed it out, but cannot think of a real use for
it. Is it for programs, PHP say, that call MySQL server and store its output in arrays, ?