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
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. :)