History for trading script

[consiglieri]

I'm trying to create custom trading script. I'm storing info about incoming and outgoing hits from last 24 hours in two separate tables incoming_hits and outgoing_hits. From these tables i fetch 24h statistics for every trader in my system and that is ok.

What i need is some kind of history, stats for last week or last month etc. What is the best way to store this kind of data? I was thinking about using sqlite flat-file db for storing daily data. This means i'd add all data from last 24h to this db at the end of every day.

Is there any better way to do this?

Thanks in advance,
Milan