Demaestro - 9:29 pm on Sep 12, 2011 (gmt 0)

Just a suggestion but if you are only writing to this table and not reading from it often or updating rows once inserted then I would suggest writing to flat files instead of into a DB.

You can have your method that does the writing create a new file for every quarter as this is what you report on. You can have a cron task compress the older files and move them to an archive directory.

It may be a little more work to build a method that will create your quarterly reports but it will be a lot less work for maintaining the data, and it should give a performance boost to other methods that are reading/writing from the DB.