TIP OF THE DAY!!! : SQL request and speed ? III

[Ruslan Zasukhin]

On 10/30/05 7:38 PM, "Thierry Nauze" <ohmitou at wanadoo.fr> wrote:

>> Hi Guys,
>> 
>> Yes SQL way takes longer time than API way.
> 
> I do not doubt it.
> But to have such a difference between two bases on the same
> rudimentary and correct request SQL is a little bit surprising.

Not so big

1) we use UTF16, so 2 times bigger strings
2) we use UTF16, so other compare algorithms, so even more slow.

3) we do a lots of checks that query is correct.
    in Sql Lite they do not have
        - constraints,
        - methods,
        - ...     
    
   so they have less work todo

....

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