Do you have any indexes on this table. Improper indexes can really hamper the database while doing inserts.
Steve -----Original Message----- From: Scott Weikert [mailto:[email protected]] Sent: Monday, May 16, 2011 12:27 PM To: cf-talk Subject: Re: Odd issue with DB "pausing" Ok just happened again... one thing to note is that when these hangs occur, all DB activity is affected. Even firing up query analyzer (SQL toolset), doing a simple query that would normally come back very quickly, it just spins. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:344547 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
