do many of the statistical queries use the whole month's data?
have you considered partitioning the log table by day? if you can
reduce the number of rows involved in the table-scans by partitioning
it'll be help performance.
I am summarising by hour, day, week and month. So I guess partitioning by day would help for the daily and hourly summaries.
Thanks for the suggestions everyone, I'll look into all these ideas.
cheers
