have you checked the connectivity between your cf server and the db server to make sure it is running normally. test the queries directly against the database server as well too see how long they take.
On Fri, Nov 18, 2011 at 6:22 PM, Dave Watts <[email protected]> wrote: > >> I've been using the query below in a CFC for months and today it started >> throwing random time out errors. Nothing has changed. >> >> Any thought as to why I may be getting errors on this query all of the >> sudden? > > What happens when you run the query directly through a query analyzer? > > What happens when you use SHOWPLAN or the appropriate alternative for > your database? > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > http://training.figleaf.com/ > > Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on > GSA Schedule, and provides the highest caliber vendor-authorized > instruction at our training centers, online, or onsite > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:348827 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
