It depends on your database server you are using. We use MS SQL Server and always go with option A, as our apps tend to be Stored Procedure driven. We push as much of our code as makes sense and is possible into the stored procedures and let the database handle the bulk of the work. Because of that 3/4 of the hardware budget is usually spent on the hardware for the database.
I'm sure others will have different opinions, but this is what has worked for me. Duane -----Original Message----- From: Che Vilnonis [mailto:[email protected]] Sent: Friday, January 14, 2011 9:55 AM To: cf-talk Subject: (ot) Server Setup Opinions I host approx. 5-6 dozen (small traffic) database driven CF sites on multiple servers and I am in the market for new server hardware. Since I last purchased hardware, the capabilities of server hardware has increased dramatically. That said, for those of you whose company hosts CF web sites, do you: A: Have a separate database server and a separate web server for 'X' number of sites? B: Have one server that is the combined database/web server for only 'X' number of sites? C: Have one 'mega' server that is the combined database/web server for all of your sites? D: Some other combo. Please explain. I guess I'm wondering if it is still frowned upon to combine the database and the web server on the same machine? Any responses would be appreciated. Che Vilnonis Application Developer Advertising Systems Incorporated 8470C Remington Avenue Pennsauken, NJ 08110 p: 856.488.2211 f: 856.488.1990 www.asitv.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:340851 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
