realbasic-plugins
[Top] [All Lists]

Re: Wow, REALGetPropValue is very slow.

To: REALbasic Plugins <realbasic-plugins at lists dot realsoftware dot com>
Subject: Re: Wow, REALGetPropValue is very slow.
From: Ruslan Zasukhin <sunshine at public dot kherson dot ua>
Date: Wed, 03 Jan 2007 17:26:33 +0200
Delivered-to: listarchive at realsoftware dot com
Delivered-to: realbasic-plugins at lists dot realsoftware dot com
Thread-index: AccvS4yGywbx+Js+Edu4AAANkzDgag==
Thread-topic: Wow, REALGetPropValue is very slow.
On 07/3/1 5:08 PM, "Björn Eiríksson" <bjorn at einhugur dot com> wrote:

> I don't see how this could be resolved at this stage given that it is a
> lookup by String value.

I believe it WAS slow because it may be _for example_ linear sting search.
Instead it can be BINARY search by hash values.

In any case, compare this SIMPLE lookup by RAM function,
And amount of job which Valentina do to insert records and save them to
disk.

    Loop on 100K records inserts with 10 fields using
    {        
        Vlong.Value
    }

Takes 1 second.

    Loop on 100K records inserts with 10 fields using
    {        
        VField.Value  i.e. Start work
            REALGetPropValue().
    }

Takes 98 seconds. 

Its simply impossible and unreasonable time!!

We just ASK from VARIANT its type.
This should be as fast as
    
    Variant.GetType { return kType; }




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


_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>

Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>


<Prev in Thread] Current Thread [Next in Thread>