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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=38 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182981 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

