Re: science fair project

[Brandon Hale <tseng pimpworks org>]

> Are you planning on running the query more than once and averaging? As I
> seem to remember that JSP will spend a little longer serving the first
> request while it compiles the byte-code for the page, and will be faster
> at each time..
Results will definately be averaged over several trials, I am thinking
10 will suffice.
 
> .. In a big mysql database I've got, I ran the query
> SELECT * FROM Img LIMIT 0,1 : first query ran at 0.80sec,
> second time round was 0.01sec- so take a look at the mySQL documentation
> to see if it offers help.... I think a similair discussion was had a
> while back on a PHP list.
Does anyone know if restarting mysqld will reset the cache or whatever
causes this speedup?

> Theres A few things to think about.

Thanks alot for the advice, Adam and Mark
;-)

I could still use help with some sort of timing script if anyone has
experience with this sort of thing. Any help on this issue would be
greatly appreciated.