IndexbyWords

[Ruslan Zasukhin]

On 11/15/05 10:29 AM, "Ed Kleban" <Ed at Kleban.com> wrote:

Hi Ed,

> Yeah, I'm sure it probably can.  But SQL REGEX is going to run a dynamic
> search upon demand looking at all records, not offer me a pre-indexed
> solution that will be able to provide an almost instant response.

right
 
> Is there a way to get a list of all the words that are in the index?

No. Not in V4RB.

Hey, Ed! you ask so advanced features!!!

May be you need go down to C++ level ?

In C++ we have IndexIterator which allow iterate unique indexed values.


> If so I could play some games by searching for a partial match among
> those candidates to greatly reduce the number of records that I'd have
> to do a REGEX search on.


> On 11/15/05 2:18 AM, "Ruslan Zasukhin" <sunshine at public.kherson.ua> wrote:
> 
>> On 11/15/05 1:29 AM, "Ed Kleban" <Ed at Kleban.com> wrote:
>> 
>>>   
>>>> Well, it is possible to check all this using V4RB exmaple
>>>>     
>>>>     Common/SplitToWords
>>>>  
>>> 
>>> Thanks.  Very useful.   Answer appears to be that words consist of
>>> alphanumerics in any order.  Is there any way to change this so that for
>>> example IndexByWords includes "_" as a character, or to make SQL calls
>>> directly to do an indexByWords on a field with the scan characteristics you
>>> desire?
>> 
>> ICU allow this, but its advanced techniques. We have not study this deeply,
>> And than more did not provide this feature to plugins API yet.
>> 
>> I think, SQL REGEX can do most thing you can wish

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