>>>A client wants a new CF server built with Win2K and CF server 4.5.1 =
(with a SQL server back-end on a different machine). Any advantages or =
disadvantages to be aware of before filling this request? Would there =
be a better combination? One last question...is 4.5.1 better than 4.0.1? =
I've read through the archives, but that seemed to turn the water into =
mud :)
My suggestion is to have a separate SQL server. I have a scalability
presentation at http://www.sccfug.org on this ... maybe it'd help a little.
The reason to split them is performance. If you're tight on cash, the app
doesn't use much SQL, datasets are small and the traffic is going to be
light, you can combine everything in one server. But as soon as data
becomes the issue, give SQL its own server. SQL 7 has a good optimizer and
when given its own ram, HD, etc., it will use whatever it can get to perform
better. So if CF is also on the server, the two compete for resources and
things slow.
--Doug
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
