Welcome to WebmasterWorld Guest from 54.166.54.215

Forum Moderators: ocean10000

keeping Track of most recently viewed products

whats the best way of keeping track of the most recently viewed products

   
2:28 pm on Jul 30, 2003 (gmt 0)

WebmasterWorld Senior Member topr8 is a WebmasterWorld Top Contributor of All Time 10+ Year Member



this site running off an access databse not sqlserver.

there is a requirement to show the most recently viewed products (3)

what would be the best way to do this?

holding the info in cookies, or tracking the customer with db entries for each page visited and pulling the most recent from the db, but filtering out matching entries. - this would be handy as it could double up as a way of analysing visitor movement, but i'm worried about bloating the access db.

am thinking that the db solution would be marginally quicker than using cookies

6:51 pm on Jul 30, 2003 (gmt 0)

10+ Year Member



I think I would probably go with the DB route also. I guess that all depends on how much strain the db is already under from page hits and record requests.
6:58 pm on Jul 30, 2003 (gmt 0)

10+ Year Member



IMO you should limit the number of connections made to an access db, so I would use cookies
8:19 pm on Jul 30, 2003 (gmt 0)

WebmasterWorld Senior Member topr8 is a WebmasterWorld Top Contributor of All Time 10+ Year Member



thanks ... more unsure now!
8:26 pm on Jul 30, 2003 (gmt 0)

10+ Year Member



sorry didn't mean to confuse you, just offering you my opinion ;o)
9:55 pm on Jul 31, 2003 (gmt 0)

10+ Year Member



The more I think about, the more I think smokin is right. Access is so bad for Web databases, the fewer hits the better. Go with the cookie.
7:53 pm on Aug 1, 2003 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



Are we talking about dynamic breadcrumbs?

This keeps track of the last 3 pages.

sub add_to_recent()
session("page3")= session("page2")
session("page2")= session("page1")
session("page1") = request.ServerVariables("URL")
end sub

10:44 pm on Aug 3, 2003 (gmt 0)

10+ Year Member



I would use aspdaddy's subroutine and augment it with code to get rid of duplicates as well.
7:49 am on Aug 4, 2003 (gmt 0)

10+ Year Member



Nice idea actually :) A thought I had was if the product id is stored in a querystring, you could just use a "productX" cookie and set it to the product id, rather than the URL. That way you can request the cookie and grab the product straight from the db. :)

Access is evil but I still use it :P

 

Featured Threads

Hot Threads This Week

Hot Threads This Month