Sessions and Web traffic analysis

[SPrelewicz]

Visitors to our site log in, and when successful we use sessions (Apache::Session::mySQL). I am now writing the logging/stats part of the application and can't decide how to handle this. Is it a bad idea to use the mySQL sessions table to generate reports, or should I create a separate table to log data?

Thanks.

 

[MikeLacey]

I would say that this depends on what data is stored in the sessions table, does this data give you the information you need to generate the reports you need in other words.

It's a difficult question to answer in the abstract to be honest -- in your position I would design the report(s) first and then look around for the data I needed to generate it or them.

Mike

Want to get great answers to your Tek-Tips questions? Have a look at faq219-2884

It's like this; even samurai have teddy bears, and even teddy bears get drunk.