Forum OpenACS Development: Re: calendar in .LRN really slow

Collapse
9: Re: calendar in .LRN really slow (response to 1)
Posted by Bernt Pettersen on 07/08/03 08:01 PM
Well, our tuning didn't help
- Shared Global Area is now 1GB
- Cache Hit Ratio is 99,94%
- Statistics gathering is on

Still, the day-summary takes more than 10 seconds.

Do you think it will help to "reindex" the indexes?
Or maybe export/import the whole DB?

- The ACS/dotLRN DB currently uses 930 MB

Collapse
10: Re: calendar in .LRN really slow (response to 9)
Posted by Dirk Gomez on 07/08/03 08:18 PM

Can you post the plan then. Also please post a count of the tables, so that we can guess where most time gets lost.

Here's a doc that describes what you have to do: Autotrace in SQLPLUS