You could call the SP using a trigger instead of using CF to call it. Might improve performance a bit. But if you really do want real-time, that 's the price you're gonna have to pay.
-----Original Message----- From: remi39 [mailto:[EMAIL PROTECTED]] Sent: February 2, 2001 2:22 PM To: CF-Talk Subject: Same Stat Question...pleaaaaaaaase help Hi there, I build a resume bank and would like to provide my user the ability t o 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 coun ter (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 th is 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 t o 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 ______________________________________________________________________ Get Your Own 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=coldfusionb 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
