Stan's slow problem

[Ruslan Zasukhin]

On 5/31/06 7:36 PM, "Stan Busk" <maxprog at mac.com> wrote:

> The 'fault' is when you select the app to monitor, press 'inspect',
> and on the window you get, select 'Statistics'. 'Faults' is on the
> left, last line.

Okay I see.

> Yesterday I made a lot of tests and as a result I am even more
> confused than before. Summing the time taken by each query, you get a
> very good timing. I removed anything else in the loop and it is still
> slow. Seems 99% of the time is wasted on the For...next. Don't
> understand it... No calculation there.

A guess.

Don't you use Vfield.Value ?

REALBasic have problem with this. Because of VARIANT.

Works VERY SLOW !!! About 20 times slower than e.g.

        Vlong.Value

> The loop without queries is instantaneous, queries are fast but
> queries inside the loop get a slow overall timing. Completely nonsense.

If above guess wrong, send me,

I will run it under profiler and see where is problem

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