Hi there,
I build a resume bank and would like to provide my user the ability to see their own stat...but i don't want to grant them access to my log files. Here is the code that runs 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 seeResume.cfm I call this simple stored proc in my seeResume.cfm page and also the other pages : CREATE PROCEDURE ... UPDATE Table_name SET XHome=XHome+1 WHERE UserID=@UserID The problem is: 1/ sometimes the counter is not updated : 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! Any advice or idea would be appreciate... thanks Remi van der Deure PS: sorry for my poor French-English ! ______________________________________________________________________ Dedicated Windows 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=coldfusiona 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
