(07-10-2017, 10:31 AM)PaulD Wrote: Thanks everyone. I have decided that I will keep the session data as clear as possible, and everything else will be table driven.

I love the term 'fingerprint' from spjonez and will be giving that some thought. If the same finger print type can be used for anonymous and logged users, that would be highly beneficial.

I have really changed my mind on this so thank you again everyone.

Best wishes,

Paul.

(07-07-2017, 12:08 PM)PaulD Wrote:

(07-07-2017, 10:41 AM)Kaosweaver Wrote: We have audit data which is like session data (we track everything from an admin's tool so we can track whatever we need to) - and our largest table is over 50 million records and 20 gigs. (we also have a fair amount of iron behind that)

Firstly, that sounds like an amazing site. Congrats on such a successful implementation. I really like the idea of your audit data. I thought I could just interrogate the session blob but actually that disappears pretty promptly so I will give some thought to something like your audit data.

Could you tell me a little bit more about how it works, or how you implemented it. Just a broad overview of course. Have you replaced the sessions with your own? Not sure I am keen on trying that, or do you just use additional tables to record data as and when it is written to sessions, so you can analyse it later (or similar). It seems like a great idea. I was thinking about logging page views of site visitors to start tracking where they go and what they do. I know there are packages that do similar but they always seem to have lots of bloat I don't need, or do things in a way I do not want. So was considering building something to work the way I wanted.

Best wishes,

Paul.