2.0.4 fc?

Ruslan Zasukhin sunshine at public.kherson.ua
Fri May 20 09:09:11 CDT 2005


On 5/20/05 5:36 AM, "Sean Wilson" <snw at paradise.net.nz> wrote:

>> And made 2 optimizations in the INDEXES, which have give speedup,
>>     believe you or not in about 10 times for that tasks we have test.
> 
> Ruslan, can you give us any idea of the circumstances under which we might
> see a speedup? What were the tasks you tested against?

I think this speedup will see people that have big dbs.
We have test on db in 500MB.

* The bigger db, the bigger index files.

1) So there was one wrong-idea which have did linear check.
Now it is disabled. So indexes do Find() several times faster.
In test I have see 8 times speedup. But if db will be 1 Gb, I think speedup
will be even more.

2) and in other place I have improve algorithm to also avoid linear
iteration, this have add yet 30% speedup.

So Indexes now in general 10 times faster.

I think small dbs also can see this improvement if you do a lots of queries.

Obviously that this speedup e.g. Joins...

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




More information about the Valentina mailing list