(no subject)

[Ruslan Zasukhin]

On 22/5/10 4:17 AM, "Bob Sneidar" <bobs at twft.com> wrote:

Hi Bob,

> UPDATE: 
> 
> Well I discovered what my problem was. I commented out the method I employed
> which used sqlYoga for all the queries, and wrote a new method using only
> RevDB API calls. The sqlYoga method took about 1 to 1.5 seconds per iteration,
> so for 100 single record queries, let's say roughly 2 minutes. The RevDB
> method took less than 10 seconds for 100 queries.


Еexcuse me but this still sounds like a very bad result.
SQL dbs can make joins of thousands records in say .001 sec

What will happens if tomorrow you will need 500 queries?
Your Users will wait 50 seconds?

Even 10 sec of WAIT is terrible for today for user IMO

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