On Apr 6, 2005 11:14 AM, Jochem van Dieten <[EMAIL PROTECTED]> wrote: > I find this weird. I was under the impression that CF threw > simple queries at the the Client Storage. Lots and lots of them, > but simple ones. That might make for a lot of lock contention and > delays, but not deadlocks.
Take a look at this new CFMX 6.1 hot fix: http://www.macromedia.com/go/19590 In particular: " � 56991 - Client variable access for sql repository not working correctly. Also changed to use the database default transaction isolation level to update client variables, if the database supports transactions. Improved deadlock avoidance when the same client variables are accessed by simultaneous pages, for example, when frames are used." This fix was already included in CFMX 7 but I just wanted to bring this point out to indicate that deadlocks were indeed possible with multiple simultaneous requests to the same client variable. -- Sean A Corfield -- http://corfield.org/ Team Fusebox -- http://fusebox.org/ Got Gmail? -- I have 50, yes 50, invites to give away! "If you're not annoying somebody, you're not really alive." -- Margaret Atwood ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:202325 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

