Tom Chiverton wrote: > On Thursday 21 Jun 2007, Jochem van Dieten wrote: >>>> As a side note, putting a database server on the same box is a bad move. >>>> The web server and database server should be separate to obtain the best >>>> in security and utilization of your hardware. >>> I believe this statement is more true for MS SQL Server than it is for >>> MySQL. At least that is what a couple MySQL experts >> Can those experts elaborate on why they believe that to be so? Do they >> have names? > > I would have though it was obvious. > MySQL eats less resources than MS SQL, so it's more able to co-exist with a > web server than MS SQL given the same hardware and loading.
The security issues with a db on the same server as CF are the same between MySQL and MS SQL Server and after testing MySQL I do not find its ability to deal with load self-evident at all: http://tweakers.net/reviews/649/6 Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create Web Applications With ColdFusion MX7 & Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281798 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4