[SPEED] Improved performance of cache work

[Ruslan Zasukhin]

On 6/14/05 7:05 PM, "Ruslan Zasukhin" <sunshine at public.kherson.ua> wrote:

> Hi All,
> 
> I have good news.
> 
> I was able just only improve performance of caching.
> 
> On million table "SELECT * FROM T"
>     
>     before          1.8 sec
>     now             0.8 sec

After little more work

        now           0.7 sec on first query
                      0.5 on next queries (i.e. cached)

If use kNoLocks for query then

        no locks     0.1 - 0.09


-------------
Btw, I have similar bench for RB2005 - SQL Lite v3
I.e. Table with million records.
        
        sql lite     24 secs

Comparing to no locks (because they do not have locks)
We get Valentina is faster 240 times on this query


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