On Wednesday 15 August 2007 00:07, Jeff Shell wrote: > We're working on something where we need to allow site visitors to > rate items. It's the basic star-rating thing. We want to keep a count > of the number of votes along with the current value.
Hi Jeff, Another possibility is of course to do external logging, i.e. to an SQL database. I use this for certain objects where I need to log every hit, Postgres easily does 100s per second, the zodb would not like it nearly as much. Was surprisingly easy to implement too (compliments to Zope!). You could use the object's intid as the key in the sql database for example, or a name, or whatever you like. I then have a view which aggregates hits per hour, and a query on top which applies an exponential backoff multiplier - i.e. recent hits are weighted more than older hits. The results of this query are cached for a few minutes using lovely.memcached (great product!), so the impact is very very low. Just another suggestion, goodluck Cheers Dennis _______________________________________________ Zope3-users mailing list Zope3email@example.com http://mail.zope.org/mailman/listinfo/zope3-users