Benji, why would you not simply generate the HTML and store it as files on the HD that the web server can then serve without database interaction. I've seen this done when the web pages were quasi-static. (Did not change with every query but changed when something on the server triggered a change) Similar to your option 2 but without the extra database. (and lose the MSSQL box and move to MySQL...had to say it to make this relevant to MySQL!) :)
=C= * * Cal Evans * The Virtual CIO * http://www.calevans.com * -----Original Message----- From: Benji Spencer [mailto:ben.spencer@;moody.edu] Sent: Thursday, October 31, 2002 8:10 AM To: [EMAIL PROTECTED] Subject: How much data can MySQL push out? We are experiencing some issues with performance on a non-MySQL box and are looking for alternatives (and alternative methods). Once of the issues that we seem to be facing, is that the pure volume of data which needs to be pushed out. The other database is pushing out (at peak) 12.5 megabytes per second and is being hit with 30-45 queries per second. If we rework the application, we end up with one of two solutions: 1) move to MySQL for the database engine (it currently is MSSQL) 2) Rework the application, so that the application still talked to MSSQL, but we generate static pages (this is for a website) and store them in MySQL, which are then served. This will reduce both bandwidth and queries per second. Bandwidth is unknown, but the queries per second are estimated at 15-25 queries per second. The select statements would be very generic though (select * from table where ID='abc123') This leaves one major question. How much data can MySQL push out? Can MySQL handle 12.5 megabytes (not megabits) per second of data? Will MySQL handle 20 queries per second? I know a lot of this also determined by OS/hardware. MySQL would be running on a 2-CPU Sun box. Any information with regards to this would be of use. If anyone also has such information on MSSQL (what is the Application Limit of MSSQL) it would also be helpful. thanks benji --- Ben Spencer Web Support [EMAIL PROTECTED] x 2288 --------------------------------------------------------------------- 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 --------------------------------------------------------------------- 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
