> Has anyone put together a FAQ about CFLOCK that would show
> examples and best practices? There are a lot of great optimization
> tips floating around, and I'd love to find a single source that
> covers most of them. Things like you just mentioned, such as
> copying the session to the request scope, and other things like
> copying a session to a local variable before using it, etc.
I'm not aware of any FAQ, other than the Allaire knowledge base article.
> Also, I'm still a little unclear on the way the locks work. If
> I lock a relatively large portion of a page, what are the implications
> for performance? Does that mean that no other browsers can access
> that page? If the lock is read-only, I'd assume that anyone could
> access it at the same time. If it's exclusive, is it completely
> unavailable for other sessions?
CFLOCK works similarly to locking within the database, in most respects.
Depending on the scope, type, and length of the lock, you may have
performance implications. Obviously, the Application scope is going to apply
to every request within the application, so it's more likely to affect other
requests. Exclusive locks will prevent any other request to access the
locked resource until the lock is released; read-only, or shared, locks will
prevent any changes to the locked resource until the lock is released.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
