Forum OpenACS Q&A: Response to Monitoring dynamic pages viewed when logged in?

Hi James,
I am also interested in the answer... What I have used for tracking Real audio useage from another server is do inserts in a log table with the user_id, cut and datetime before redirecting the user to the audio file.

I want to expand this to include specific (dynamic) page views by specific users. There are two possible ways of doing this:

  1. Continue same model with INSERTS into the log table after the page is rendered with
    ns_return 200 text/html ....
  2. Or use UPDATES into table (Inserts if new) based on user_id and have an integer field that is incremented to show number of times that user has viewed the page and restamp the datetime.

So, which method is more efficient? Are there better ways to do this that will allow for moderate to high usage?