Hi, Just a silly question: are you pushing those 12.5 Mbytes/s over the network ? If this is the case you have hit the limit of Fast Ethernet (12.5x8 = 100Mbits/s) and no database (not even MySQL ;) ) will be faster ! May be an upgrade to Gigabit Ethernet would help...
Regards -- Joseph Bueno Benji Spencer wrote: > 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
