> Specifically, they want the cold fusion app to be able to dynamically
point
> to the backup database if the primary one is down. The snippet that was I
> given as a sample polls the databases in the Application.cfm file as
follows:
[SNIP]
> My concern is for the efficiency and load implications of this. Will this
> slow my app down substantially? Would running this snippet every minute
or
> so as a background task be better? Is there a better way?
Yes, that's extremely expensive. Don't try it. If you must go this route,
catch DB errors using <CFERROR TYPE="Database"> and run your check from
there. Then set an application variable to the backup server.
However, I think that asking CF to do this is a bad route. What DB are you
using? Oracle has native support for DB failover, that can even replicate
partially finished transaction across failed DB's. (Look at Parallel Server,
Distributed Server, and FailSafe). SQL Server should have similar
capabilities, though I've never used it. Try using your native DB interface
to do failover before you ask CF to do it.
+============================================
+ Benjamin Smedberg
+ CUA Assistant Webmaster
+ [EMAIL PROTECTED] - http://computing.cua.edu/as/bds/
+============================================
+ He is risen, as He said! Alleluia!
+============================================
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
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.
