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
Windows or Linux? What type of DB? MS SQL? mySQL?
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
Windows or Linux? What type of DB? MS SQL? mySQL?
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
It used to be very bad to have DB and CF on the same server, but I'm not
sure that's still the case ... probably depends largely on the RDBMS you're
using. In any event, it is certainly best practice to have production
boxes separate. Running dozens of databases (or even 100) on a single DB
Windows or Linux? What type of DB? MS SQL? mySQL?
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
Oops sorry for the dupe.
Windows or Linux? What type of DB? MS SQL? mySQL?
www.asitv.com
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
No problem. Were a Windows shop. So it will be Microsoft 2008 R2 for the OS
and the DB.
-Original Message-
From: Kelly Matthews [mailto:ke...@webdiva.org]
Sent: Friday, January 14, 2011 8:59 AM
To: cf-talk
Subject: Re: (ot) Server Setup Opinions
Oops sorry for the dupe.
Windows
I'd go with option A. The one time I had SQL and CF on the same box it caused
issues and was not efficient.
No problem. Were a Windows shop. So it will be Microsoft 2008 R2 for the OS
and the DB.
Oops sorry for the dupe.
You will never get the best performance having them on the same server, but
disks is the real bottleneck. As long as you have your databases running of
a different physical disk than everything else then you can get away with
having it all on one machine, more so if you can isolate the CPU's or
-talk
Subject: Re: (ot) Server Setup Opinions
I'd go with option A. The one time I had SQL and CF on the same box it
caused issues and was not efficient.
No problem. Were a Windows shop. So it will be Microsoft 2008 R2 for the OS
and the DB.
Oops sorry for the dupe
Actually - that is a point in FAVOR of combining the 2. If you have
2 servers - one for database and one for Webserver/CF, a failure on
either one will bring down all of your websites. You double the
chance that there will be a problem.
I run a server that combines everything.. It only
-Original Message-
From: Al Musella, DPM [mailto:muse...@virtualtrials.com]
Sent: 14 January 2011 16:51
To: cf-talk
Subject: RE: (ot) Server Setup Opinions
Actually - that is a point in FAVOR of combining the 2. If you have
2 servers - one for database and one for Webserver/CF, a failure
-Original Message-
From: Al Musella, DPM [mailto:muse...@virtualtrials.com]
Sent: 14 January 2011 16:51
To: cf-talk
Subject: RE: (ot) Server Setup Opinions
Actually - that is a point in FAVOR of combining the 2. If you have
2 servers - one for database and one for Webserver/CF, a failure
13 matches
Mail list logo