Hi, I was wondering where the limits of MySQL are. I need >2000 updates per second on a table with +-200000 rows. I was wondering what the ideal hardware to accustom that would be. For the moment a SunFire 280R with 1 CPU and the table in memory (heap) seems to be able to handle 1800 updates a second. Is there a way to gain more speed, to update even more ?? Would a second CPU help? -- Thierry Coopman - [EMAIL PROTECTED] My opinions are personal, and have really nothing or nothing to do with Keytrade! #RandomTag --------------------------------------------------------------------- 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
