Sounds to me like you have been talking with a MSSQL preacher. mySql is a "enterprise" DBMS solution. The only differences in the community edition and the enterprise edition of mySql is support and timely updates and bug fixes. Just a few who use it.
Yahoo! Finance, MP3.com, Motorola, NASA, Silicon Graphics, Siemens and Texas Instruments. Doug B. ----- Original Message ----- From: "Richard White" <[EMAIL PROTECTED]> To: "CF-Talk" <[email protected]> Sent: Thursday, January 25, 2007 5:17 AM Subject: Help with selected database > 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:267593 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
