Forum OpenACS Development: Re: Suggestions for calendar scalability?

Collapse
Posted by Dirk Gomez on
Can you post two executions plan: one with the ORDERED hint, one without it. Then we may be able to see why Oracle goes wrong.

As to scalability of the data model: I have a half-finished version of calendar that doesn't depend on acs-events anymore (PG). There is so many tables joined in this query - it's probably impossible to make it scale nicely.