3 questions

[Ruslan Zasukhin]

On 20/10/07 1:32 AM, "Joseph Morgan" <joseph at checkos.com> wrote:

Hi Joseph,

>> For example
>> 
>> 1)  Vlong.value as Ulong
>>     Vfield.value as Variant
>> 
>>     RBDB have only Variant way.
>>    But when you know EAXCT type of value this speed up things in
>> times.
>>     and problem here in fact that RB's type() function of VARIANT
>>     is about 100 times slower then it must be.
>>     I have report them this 2-3 years ago but not fix still.
> This hasn't been an issue for me in the past since I rarely use VARIANT.
> I was told it was really slow so I always made sure to almost always
> know what type I am dealing with.

Moment please. 

How you can in RBDB do

    rc.Field(i).value  AS LONG or AS DOBULE

I have not see such things there.

  
>> 2) or ability in SqlSelect() specify array of binds.
>>     this can speed up thins up to 20 times

> I am not sure what a bind is, maybe I should look into this?
> Is this similar to binary link?

No, this is usual feature for most mature RDBMS

        WHERE fld = :1  ...
or    
        WHERE fld = ?  ...


This feature bring speed together with Query Pool which works behind of
scene.


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