I have a question regarding Validation Query: The CF 9 online help says this about the Validation Query: Called when a connection from the pool is reused. This can slow query response time because an additional query is generated. You should specify this just before restarting the database to verify all connections, but remove the validation query after restarting the database to avoid any performance loss. If you are pointing to an Oracle RAC Cluster containing 2 nodes and want to ensure that the RAC node the connection is currently bound to is viable doesn't it make sense to leave the validation query in place? (select 1 from dual;) regardless of the small performance hit I would rather prefer that my connection is viable.
What is everyone's opinion on this? Thank you in advance. [circle]<http://www.suny.edu/> Alex DeMarco Manager of Technical Services The State University of New York State University Plaza - Albany, New York 12246 Tel: 518.320.1398 Fax: 518.320.1550 Be a part of Generation SUNY: Facebook<http://www.facebook.com/generationsuny> - Twitter<http://www.twitter.com/generationsuny> - YouTube<http://www.youtube.com/generationsuny> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:354943 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
