Doug, I did not read his comments as MS SQL questions. These are typical DBA questions when anticipating load and consumption of resources. These questions will determine how much optimization is needed and disk storage space will be needed.
Queries per second multiplied by the average length of a row will give you the base line of the storage you will need. Typically once you know this number, you double it and anticipate the initial estimate as a SWAG (Severly Wild Arse Guess). The insert/update/delete would suggest how your DBMS handles each transaction. Yes, in the MS SQL Server realm, an update is two transactions. One to delete to row and one to insert the update to the row. The choice of the RDMS will be based upon budget and intellectual knowledge of your support staff. I would suggest contacting each of the vendors you are interested in for a set list of questions. Oracle, Microsoft and MySQL are typically the top three currently. Teddy On 1/25/07, Doug Brown <[EMAIL PROTECTED]> wrote: > > 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:267595 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
