----- Original Message -----
From: <[EMAIL PROTECTED]>
To: "mySQL list" <[EMAIL PROTECTED]>
Sent: Tuesday, January 16, 2001 3:57 PM
Subject: Why does 1st query take so long?
> I've noticed that when developing queries involving complex joins on
> tables I sometimes seem to get appallingly long times the first time I run
> a query, but the second and subsequent time I run it - even substituting
> a different value for a field value I'm matching on - the query runs
> quickly.
>
> Does mySQL do some behind-the-scenes reindexing the first time,
> resulting in the speed differences I see? If so is there some way I can
> force it to re-build indices periodically so I can ensure that queries are
> generally fast? Is this the point I should be going out and buying a book
> about mySQL? ;-)
I think its because the Operating System is caching the data the query are run on
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
