Efficient use of text-containing field

[Ruslan Zasukhin]

On 12/6/05 5:02 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 ...
>> 
> 
> I'm sorry, but I want to  make sure I understand.
> 
> Can I do a non-method sort on fields that are indexedByWords?

NO.

> My understanding is that this is not possible (at ANY speed).

right

> That is why I use a sort method.

right

> If it *is* possible to sort an indexedByWords field (again, speed is not an
> issue for me), please tell me how.

No way currently. 

I have talk about future feature
You sure you will not complain later?  :-)


-- 
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]