Jon Lewis wrote:
> If you often need this data sorted, depending on where the data comes
> from, you might consider using an SQL table to store it. The table can
> have indexes sorted on the fields you'd want to see the data sorted in,
> which spreads the sorting work over the time during which data is
> entered into the db...making the select that generates sorted data much
> faster than using sort on hundreds of MB of unsorted data.
That's a good idea... I remember doing that once and there is an "easy"
mysql command to load the data from a flat file. Of course, I don't
have the syntax in my head.