Subject Re: [ib-support] Order by and BLOB field
Author Ann W. Harrison
At 04:05 PM 12/19/2001 +0100, Paul Reeves wrote:

>In any case, you can't index blobs, so your order by could be painfully slow
>if a large result was returned. Perhaps you could store the first eighty chars
>in a varchar field, index it, and order by column instead?

Sorting is faster than an index walk unless the data is stored in
the same order as the sort.


We have answers.