I am new to MySQL to begin with. I am running syslog messages to a DB. It sends anywhere from 3500 to 5600 per minute. I then use PHP to look at the data. The DB machine is a Dual 1Ghz processor with 1Gb Ram. The problem is the speed of lookups. The DB has about 7 million rows and is continually growing. Should I break this up by the day to speed up searches? It takes about 2 minutes to do a search on the data. Just looking for pointers.
Thanks Bennie -- ************************************** Bennie Warren LemooreNet 320 West D Street Lemoore, CA 93245 Phone: 559.924.5909 Fax 559.924.9578 [EMAIL PROTECTED] http://www.lemoorenet.com ************************************** --------------------------------------------------------------------- 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