Ignore the first part of my reply, I did not get the second part of thread at the same time as the first reponse.
On 1/25/07, Teddy Payne <[EMAIL PROTECTED]> wrote: > > 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:267599 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
