Hi there,
I build a resume bank and would like to provide my user the ability to see their own stat through thier browser...but i don't want to grant them access to my log files. Here is the code i run when someone browse a page : XHome is the counter (and a column name in my SQL Server DB) updated everytime a user see my page Resume.cfm I call this simple stored proc in Resume.cfm every time a user see this page CREATE PROCEDURE ... UPDATE Table_name SET XHome=XHome+1 WHERE UserID=@UserID The problem is: 1/ sometimes the counter is not updated : is there a cache problem or something else...i don't know? 2/ More important : i don't think it's The Solution as i don't want to kill my server (shared hosting ! ). There will have a lot of traffic if i update my counter (my DB) everytime a user launch this page! Should i increment a text file? Am i missing something...Any advice or idea would be appreciate... thanks Remi van der Deure ______________________________________________________________________ Why Share? Dedicated Win 2000 Server � PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc 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
