Forum OpenACS Development: Re: max_child_sortkey purpose

Collapse
3: Re: max_child_sortkey purpose (response to 1)
Posted by Don Baccus on 11/09/05 02:16 AM
In particular max() is slow in Postgres as it scans every row returned by the select.

Your method will slow down linearly as new children are added to the parent. That's not good.