Grigor, Peter wrote:
If you are using a version of MySql that has the query cache you can turn itUnfortunately, they change a lot more often than I run the queries; its a mostly-update table for storing intrusion detection information.
on and those queries will run very fast after the initial query. The query
cache is cleared whenever the underlying table(s) are modified so you'll get
the initial time hit again after modification...but if your table contents
don't change much the query cache will make a BIG difference.
--
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http://www.fibrespeed.net/~mbabcock
---------------------------------------------------------------------
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
