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?

Regards,


Ann