Richard White wrote: > > We have developed an online application that is about to start the > pilot test. We are currently using MySQL as the database but i heard > something a little concerning yesterday. > > I thought MySQL was built for concurrency, alot of users, and alot of > records. > > I was told that MySQL was limited and that i should be using MS SQL > Server with Database Manager 2k.
Have you done any load testing on your application with a realistic workload and a realistic database size? > At maximum our application will have 30,000 users, I'm not sure on > concurrency yet as it is so far untested but i will guess at around > 1000 (the system has been designed to limit the amount of concurrent > transactions). The total amount of records in 2 of the tables could > also reach into the millions. How many queries per second do you expect? How many of those will be INSERT/UPDATE/DELETE queries? How many rows will the average query return? Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267589 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
