Anecdotal evidence so far indicates the hangs occur when writing to a given table - not reading, that's for sure. It's when a client is saving content - which in our system is pretty much the spot where the most content can be written to the DB.
And no, no locks or transaction settings in that part of the script. Earlier in the script, I do use cftransaction around some other queries. It's kind of a two part sitch - I have one table called "TDocument" that stores the particulars about a given document, and then "TParagraph" which stores the individual content bits for said document. It's around TDocument I have cftransaction - around TParagraph calls (either update or insert) I have no transaction setting. (I have it around TDocument because when inserting a new doc, it also needs to write out that new ID to a lookup table.) The TParagraph table has an ntext field that holds the main content. Used to be just a text field, went ntext about a year ago to accomodate diff characters. Haven't had the hang issue til recently though. On 5/16/11 9:58 AM, Maureen wrote: > Are you doing any locking on the DB? If it is always happening with > when querying the same table, you could be getting locks or conflicts > on that table. > > On Mon, May 16, 2011 at 8:53 AM, Scott Weikert<[email protected]> wrote: >> Yep, there's quite a few queries without cfqueryparam - but again, this >> is behavior that has popped up of late - this is code that's been around >> for years that hasn't had this sort of issue. So I don't know that this >> is a problem. > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:344542 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
