Hi. I have a database table with a single row and following columns:
TotalMembers
RegisteredToday
NewestMember
I update this row everytime someone registers. My question is, how
should i control simultaneous updates/locking/unloking issues?
Please help. Here's what i am doing right now:
<cftransaction>
<cfquery>
UPDATE db_sitestats
SET TotalMemembers = TotalMenbers+1,
RegisteredToday = RegisteredToday+1...
</cfquery>
<cfquery name="getstats">
Select * from db_sitestats
</cfquery>
<cfset application.TotalMembers = #getstats.TotalMembers#>
<cfset application.RegisteredToday = #getstats.RegisteredToday#>
</cftransaction>
Please tell if i need to do anything else. These Stats are always
shown on the homepage of the site.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://www.adobe.com/products/coldfusion/flex2/
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272366
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
