I am looking at an application that will be could be potentially writing hundreds of records a second (syslog) to a MySQL database. I expect to reach millions of records (if not billions) in time.
I will be doing a variety of types of queries on the data which will be anything from summarization of certain types of data to full pattern matching. So, my question is which of the database formats would be best suited for this type of environment? The MyISAM seem to work well on receiving the data, but the InnoDB database style seems better suited for the queries. Any ideas anyone? Richard --------------------------------------------------------------------- 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
