I thought it could be a good idea to see what customers are looking at the most. However it maybe more useful to know what they bought instead so I guess on this occasion no.
I have read that temporary tables in Mysql can be created and be destroyed when session had ended maybe this is the way to go.
What do you advise?