Re: Real-Time Stats Plugin Released

[James Keating <ja...@okeating.net>]

A new version of the plugin has been released thanks to Andrew Donkin 
who provided a variety of updates for the code.  The updates include the 
following changes -

- Removed the exists sub as it is not necessary when using an INSERT 
with ON DUPLICATE KEY UPDATE.

- Removed the TOTALS insert and the totals column. These are not 
necessary and can be calculated via select statements.

- Changed the table schema to remove the totals field

- Numerous other changes

The code is much much smaller now and faster.  It is backwards 
compatible with the old table schema, but a new table schema (without 
the totals column) is available.

Code can be found at the SpamAssassin Wiki -
http://wiki.apache.org/spamassassin/StatsPlugin

Or at my bl0g -
http://www.okeating.net/blosxom.cgi/2006/01/08#statsplugin-update-010706

Thanks Andrew for your great input and code!

- James


Andrew Donkin wrote:
> James Keating <ja...@okeating.net> writes:
> 
> 
>>Morning All,
>>
>>   I have released a real-time stats collection plugin
>>(http://wiki.apache.org/spamassassin/StatsPlugin)for SpamAssassin.
> 
> 
> Actually James, now that you have that atomic insert/update in there,
> you can get rid of $user_exists, $total_exists, the last parameter to
> execute_stats(), and get_current_entry().
> 
> I am running with that version and it is working well, at about one
> update per second.
>