If I want to restrict the operation below so only one user can effect it at a given
moment, is there a better way than the code below? Bottlenecking it like this bugs
me.
Every first-time visitor will hit this once. Traffic is 250-1000 daily sessions. I'm
using mySQL. Any thoughts or better ideas would be much appreciated.
<CFLOCK
NAME="#application.ApplicationName#"
TYPE="EXCLUSIVE"
TIMEOUT="10">
<CFQUERY DATASOURCE="#request.foo#">
UPDATE entrycount
SET
entrycount.InstallFlash=(entrycount.InstallFlash+1)
WHERE
entrycount.ID = 1
</CFQUERY>
</CFLOCK>
---------------------------------------
Matt Robertson [EMAIL PROTECTED]
MSB Designs, Inc., www.mysecretbase.com
---------------------------------------
______________________________________________________________________
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
