I honestly don't know the answer to your question. I'm not really an expert on MySQL. And it could be a number of things, unless somebody would be really familiar with your setup. And even then, it takes time.
Merry Xmas. --- mike t. ----- Original Message ---- From: Jun Martin <[EMAIL PROTECTED]> Thanks, Michael. Now can you tell me why selecting data from a few tables in a mysql database (being used daily by tellers posting payments and new bills getting posted by the thousands daily) usually takes 20 minutes but takes only 4 minutes when the mysql service has been restarted less than one (1) day prior to the query?
_________________________________________________ Philippine Linux Users' Group (PLUG) Mailing List plug@lists.linux.org.ph (#PLUG @ irc.free.net.ph) Read the Guidelines: http://linux.org.ph/lists Searchable Archives: http://archives.free.net.ph
