To Joakim about speed of first query.

[Ruslan Zasukhin]

On 26/4/07 3:28 PM, "Joakim Schramm" <joakim at astrocalc.com> wrote:

>> Of course we will. Do not worry.
>> Than more that you say Access do not show this behavior.
>>  
> Well some year ago I had this data loaded into an Access database for
> testing, which of course couldn't deliver the speed I wanted but at the time
> I was not able to find any other usable db for local application (not
> server). I will recall a partial search like "StartWith" didn't take this
> long although it was slow. But I am sure there were no such behave on very
> first query, for sure.
> 
> So at that time I kept things in text files as it was faster. Later I found
> a db called Tsunami, which is Btree based I think, not relational and no
> SQL. It was pretty fast though, but a bit complicated to work with and not
> as fast as Valentina. There was no such first query behave though on a
> partial search. I can't recall exactly now and I have no longer access to
> their support forums, but it sure was many times faster then Valentina on
> this first query.

A guess: MAY BE:

They both, especially a btree, have return only FIRST found item,
Then you did ask second, and third and ...

Valentina finds ALL matches at once. And even set records locks, if you use
Vcursor.


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