[NEW] very fast REINDEX -- 100+ times faster!

[Ruslan Zasukhin]

Hi All!

we are happy inform you that we have got success with implementation
of a new REINDEX algorithms for Valentina.

They work in 100+ times faster than the old.
    
For example, 5 millions records old algorithm did reindex in 10+ minutes
New in 6-9 seconds (I think still possible improve this result).
    G5 DUAL/2.0 

Also this algorithm create indexes much more compact.
Usually about 2 times less.

So now you have way SIGNIFICANTLY REDUCE THE SIZE of your database before
you put it on CD/DVD (also it is clear that the smaller indexes the faster
speed of search/access).

---------------------------------
EXAMPLE: we have user with tables that have 10 and 20 millions records in
each. For ULONG fields:

    10M table --  old index = 240MB
                  new index = 120MB

    20M table --  old index = 480MB
                  new index = 240MB

Note, this is only for ONE index.
If you have e.g. 10 indexes, it is easy calculate how big economy is.

-----------------------------------
For now this algorithm works IF:

    * this is a numeric field <= 4 bytes
        i.e. Byte, Short, Ushort, Medium, Medium, Long, ULong,
            Float, Date, Time.

The next task for us is to develop similar algorithms for string fields...


This new algorithm will be available in the next beta build of Valentina
products and in 2.4 release.



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