Welcome to WebmasterWorld Guest from 23.22.200.6

Forum Moderators: ocean10000

Message Too Old, No Replies

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)

Senior Member

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

joined:Apr 19, 2002
posts:3180
votes: 8


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 July 30, 2003 (gmt 0)

Junior Member

10+ Year Member

joined:July 18, 2003
posts:43
votes: 0


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 July 30, 2003 (gmt 0)

Junior Member

10+ Year Member

joined:July 3, 2002
posts:82
votes: 0


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

Senior Member

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

joined:Apr 19, 2002
posts:3180
votes: 8


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

Junior Member

10+ Year Member

joined:July 3, 2002
posts:82
votes: 0


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

Junior Member

10+ Year Member

joined:July 18, 2003
posts:43
votes: 0


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)

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:June 13, 2002
posts:2162
votes: 0


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)

New User

10+ Year Member

joined:Apr 1, 2003
posts:20
votes: 0


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)

Preferred Member

10+ Year Member

joined:July 2, 2002
posts:529
votes: 0


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

 

Join The Conversation

Moderators and Top Contributors

Hot Threads This Week

Featured Threads

Free SEO Tools

Hire Expert Members