On 17 Oct 2006 at 9:54, Todd Brasseur wrote:

>That was my thinking as well. But I wondered if there was some
>magical way to do this in the database so we would be protected either
>way. We try to encourage clients not to update themselves directly
>(not through the application) but we can't totally control them.

The subject of "stored aggregates" is wery controversial. In most
cases the first suggestion is "don't use them at all". Are you sure
that assessments can't (too slow) be calculated on-the-fly?

--
SY, Dimitry Sibiryakov.