On 22/5/10 4:17 AM, "Bob Sneidar" <[email protected]> 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] _______________________________________________ use-revolution mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
