If your counter isn't being executed, it could easily be a caching issue. Many large ISPs run caching proxy servers for dialup and broadband users. If you don't specifically try keep pages from being cached, you could be seeing the results of this.
You may also want to record date information so that users know _when_ the traffic to their pages occurred. Perhaps one record per page per day (or month - whatever is sufficient). Is running these database queries really going to be significant when compared to other processing on each page? Is this information available in your server's web logs? That's to say, is the page name plus the query_string (url variables) enough to uniquely identify your users' pages? If so, write a program to process the web logs every night and update your database. It should be less costly than doing it real-time. Of course, results would only be current through the end of the previous day. If you do this, you'll want to rotate your web logs on a daily basis and make sure that your web server is recording the query_string in the logs. Jim ----- Original Message ----- From: "remi39" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, February 02, 2001 2:22 PM Subject: Same Stat Question...pleaaaaaaaase help > 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 ______________________________________________________________________ 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
