SQL request and speed ?

[Ruslan Zasukhin]

On 8/17/05 7:34 AM, "Claudius Sailer" <Claudius at sailer-online.de> wrote:

>> I think it is NOT so much slower.
>> 
>> Can be affect of changes in behavior, which developers do not realize.
>> 
>> * for example in v2 if you set flag fUnique or fIndexByWords,
>>     this DO NOT means that field already indexed.
>> 
>>     so such code will do non-indexed search
>> 
>> * OR Valentina 2 do not create index on non-indexed field as did v1.
>>     instead it just do non-indexed search
> 
> Okay. Are IDs already indexed?

IDs - you mean primary key?    YES
        Or RecIDs              they do not need index


> Whats happen with VObjectPtr?

By idea must be. 


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