> 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