I'd use the old one as the DB server. We've got three identical machines, two web/app server and one DB server (white lie). Even whent he app servers were running full-bore during load testing, the DB server was still at very low utilization. YMMV, of course, but DBs are insanely optimized for speed, so unless you got one hell of an optimized application, the app is probably going to run slower.
cheers, barneyb On Fri, 29 Oct 2004 15:22:21 -0400, Claremont, Timothy <[EMAIL PROTECTED]> wrote: > I have two servers available to me. A brand new, "latest and greatest" > dual proc. 3.2 GHz machine with 2.5 gb Ram, and a lowly dual processor > 550 mhz with 1 GB Ram. > > My app will be doing a LOT of db calls/queries/updates. > > With SQL and FoxPro database backends, should I put the dbs on a > separate server from the web stuff, or am I better off using the new > server for both roles? If I *do* separate them, which should I relegate > to db server duty? > > Ignoring security and single-point-of-failure scenarios, is the old > machine so poor of a performer that it negates any speed advantage of > having separate web and db servers? > > -Tim -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/blog/ I currently have 0 GMail invites for the taking ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=34 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182989 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
