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
