Top Citizen Charts now delayed

I've had to implement a delay on the updating of the citizens charts. These are now recalculated every hour. This was necessary as it requires a couple of temporary tables to be created to derive the net support information and with getting on for 2000 voting records now in the database, this was getting to be quite an onerous task every time the homepage was displayed. Most people will have noticed that the top 10 doesn't change that frequently, and this is partly to do with policy discovery. Although there is a constant stream of new members, they appear to be finding it hard to discover existing policies, instead prefering to pick from those in the recently change and most active categories. We are seeing over 100 votes being cast per day however.

The delay on the charts does help with the implementation of a new feature (coming soon) that will allow you to plot a graph of your support over time. That should make things much more interesting. Now all I've got to do it write it!