Forum OpenACS Development: Re: Lacking views in CR

Collapse
9: Re: Lacking views in CR (response to 1)
Posted by Dave Bauer on
Surprisingly according to my last post, the additional where ci.item_id=cr.item_id makes PostgreSQL faster. So it looks like this performance issue is unique to Oracle. The query still takes .5 secs, but we know count is not fast on PostgreSQL under an circumstances.