Efficient use of text-containing field

Tue Dec 6 16:06:36 CST 2005

On 12/6/05 2:58 PM, "jda" <jda at his.com> wrote:

> As for the sortmethod, this is unavoidable in Valentina if I need to
> sort by this field. I have suggested in the past that Valentina
> default to sort by entire field if the field is indexedbywords. That
> would mean I could get rid of about 30 sort methods!

There is no way to sort BY INDEX which is by words.

So choices will be

A) do not indexed sorting. slowest
    can be acceptable only if you have small selection of records.
    and more overhead here

B) ... Still have some index ...

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]