Re: Witango-Talk: Record Counter

[Robert S. Sfeir]

OH!  That's a different story.  I would insert a record the first time it gets hit in a table with record ID and Counter number, then when it gets hit again, update the counter number.

R

Scott Yoshinaga wrote:

I need to know how many times it was accessed so i can update how popular
a record is compared to others.



On Thu, 20 Jun 2002, Thomas Ferguson wrote:

  

To get what you're asking, you'd need to increment a counter in the record
each time you read it, which would mean a read and an update for every
record browsed.  This would certainly negatively affect performance.

Do you really need to know how many times each record has been accessed, or
just how many times its been updated?

-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Scott Yoshinaga
Sent: Thursday, June 20, 2002 6:26 PM
To: Multiple recipients of list witango-talk
Subject: Re: Witango-Talk: Record Counter


thats possible but i need a live update on the record itself to show how
many times its been accessed.




On Thu, 20 Jun 2002, Robert S. Sfeir wrote:

    

All these suggestions PLUS:

If you have a server log you can run webtrends, or Bolero if that's
still around, or something looking for a string in the search, this is
assuming that you have a URL which looks something like this:

http://domain.com/sometaf?_function=get&id=21

where the 21 would be the file or record ID you're looking for.

This method is non invasive to your app and give you the flexibility to
get different reports in the way you want to see them.

R

Thijs Kroesbergen wrote:

      

Howdy,

You could put a trigger on the "select" statement. Then have the trigger
update another table which holds the counter.
This only works if your database supports triggers of course.

-thijs



        

-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Scott Yoshinaga
Sent: Thursday, June 20, 2002 12:30 PM
To: Multiple recipients of list witango-talk
Subject: Witango-Talk: Record Counter


Hi All...

I was wondeering if any of you have found a way to count how many times
          

a
    

single record in a database is viewed.

Has anyone needed to do something similar to this?

aloha!
\\scott\\


________________________________________________________________________
TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED]
               with unsubscribe witango-talk in the message body




          

________________________________________________________________________
TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED]
               with unsubscribe witango-talk in the message body


        

________________________________________________________________________
TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED]
                with unsubscribe witango-talk in the message body

________________________________________________________________________
TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED]
                with unsubscribe witango-talk in the message body

    

________________________________________________________________________
TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED]
                with unsubscribe witango-talk in the message body