At 08:11 AM 5/30/01 -0400, you wrote:
>Yep, that's one thing I look at very closely when building a new DB any
>time, I try to make it as efficient as possible and I also try to let SQL
>server do as much of the work as I can. But then I also have the luxury of
>having two separate boxes, one for SQL Server and one for CF so it's pretty
>easy to break the two out and let one do it's part of the work and the other
>the other.
Whether you have one box or 1000 boxes, SQL Server or any RDBMS is the
proper place to do this kind of processing. ALWAYS target work that can be
done in the DB to the RDBMS unless there is a specific reason why it needs
to be done in another language or there are real performance gains by not
doing the work in the DB.
-dhs
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
