I just wanted to say that MySQL absolutely rocks! We are using Mysql with a very large database and it's working beautfully. Needless to say we will be buying licenses to further support mysql.
Here are some rough stats on what we were doing: Inserts: 13,000,000 per day Updates: 12,000,000 per day Queries: 12,000,000 per day This process has been running for almost a year with no problems. This puts the total number of inserts, updates and queries at about 5 billion EACH for the year. Thats 5 billion inserts and the system is idle about 50% of the time, so there's plenty of room for growth. We use Myisam tables to store the raw and summary data, Innodb tables to keep track of the batch transactions, Merge tables to query large numbers of rows accross many tables, and Heap tables to quickly reduce raw data into summary data. Again, cheers to the mysql development team for a job well done. --Mark --------------------------------------------------------------------- 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