Ulrich =?iso-8859-1?q?Sch=F6bel?= <[EMAIL PROTECTED]> wrote:
>
> % time {db eval {select * from cust_persons where first_name='Ulrich'}} 1000
> 75.498 microseconds per iteration
> % time {db eval {select * from cust_persons where first_name='Ulrich'}} 10000
> 51.6179 microseconds per iteration
> % time {db eval {select * from cust_persons where first_name='Ulrich'}} 100
> 309.95 microseconds per iteration
> % time {db eval {select * from cust_persons where first_name='Ulrich'}} 10
> 66.8 microseconds per iteration
>
> Where do those 309.95 microseconds come from? What's the
> difference between running a query 100 times or 10000 times?
> Should I avoid running a select exactly 100 times for some
> obscure reason?
>
FWIW, I am unable to reproduce your problem) I get
a smooth transition from 10 iterations (84 uS/iteration) to
10000 (58 uS/iteration).
What OS are you using? And what version of Tcl/Tk?
--
D. Richard Hipp <[EMAIL PROTECTED]>
