"Jamie Tufnell" writes:
> item_count int -- this is derived from (select count(*) from items
> where group_id = id)
> ...
> item_count would be updated by insert/update/delete triggers on the
> items table, hopefully that would ensure it is always correct?
> I'm wondering is what I'm trying to
Hi,
I (think I) want to denormalize an aggregate for performance reasons.
I think that is the right terminology, please correct me if not.
Consider these two tables:
items:
id serial (pk),
group_id int (fk),
...
groups:
id serial (pk),
item_count int -- this is derived from (select count(*)