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
