Subject Re: [firebird-support] Re: ORDER BY on large VARCHAR columns
Author Ann W. Harrison
At 05:31 PM 10/26/2004, robert_difalco wrote:

>It's interesting that there are no standard solutions for this. I
>was certain Helen would have an easy sure fire way to ORDER BY
>quickly with large un-indexable VARCHARs.
>So, how about quick ordering by a BLOB field? Anyone have some good
>solutions for that? I could always make this field a BLOB instead of
>a large VARCHAR.

That would certainly make the problem worse. How many records are
you retrieving? How long are the keys? Are you sure that the sort
is the problem?