What is the best way to store website statistics?

[linkin123]

Do you have an experience on how to store website statistics including keywords and time..by day and month..etc?
do you have an experience on how to design such tables to store statistics?

any ideas would be helpful

 

[linkin123]

just to clarify..im not actually lookin for a code
just a pseudocode and ideas on how to approach the problem

 

[guelphdad]

don't store them by day or month by any means. you should have a datetime or timestamp field with your data. you would use your query to arrange data by day, month, time of day etc.

without knowing what you want to store it is hard to say. You should know your data. Do a quick read on DATABASE NORMALIZATION so that you have an understanding of this basic concept.

then design your table(s) without data and post them here. People will have an idea of how to help you adjust your table.