Hi, 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. Just thought id get some expert opinions on it. 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. I would appreciate any advice at all. thanks ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:267587 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
