V4RB next beta. Anybody want it right now ?

[Ruslan Zasukhin]

On 10/4/04 12:19 AM, "jda" <jda at his.com> wrote:

>> It can show example with new string search methods.
>> 
>> I am waiting for answer 10 minutes
>> 
> 
> I'm here...

Ok, files uplaoded

You need update all 3 archives.
New ICU libs.


----------
Look at example API/IndexByWords

It show new API functions.

Tomorrow I will make yet interface I_FldString that will present in Vstring,
Vtext, and VarChar fields. Because now it is not comfortable to call this
methods: we must explicitly cast to Vstring or Vtext.


SQL way to access index by words not works yet.
I think tomorrow it will be ready.


-------------
StartsWith -- do as indexed so not indexed search.


Now let's look on EndsWith and Contains.

We have implement that in case EXISTS an index, then we do INDEX SCAN.
What this means?

Let you have in table in column say million records.
Let record have just one word.

Valentina 1.x will do SCAN OF COLUMN, i.e. It will load and compare million
of words.

Valentina 2.0 will use index. For example, if from million words we have
only 20,000 that are distinct, then INDEX SCANN will do index iteration and
only 20,000 compare.

Also index scan works for FindContains().

Also we need yet implement for FindLike()


In other words, even such NOT-indexed operations as LIKE, EndsWith,
Now will be faster than in 1.x



-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------