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

Collapse
Posted by Don Baccus on
Make sure that statistics gathering is happening (install is supposed to set this up automatically but it doesn't hurt to double-check)

Make sure that shared pool size and various other Oracle settings are set large enough (your dba should be able to help you here)  You should be seeing essentially zero disk I/O for read-only queries like this.

We know we need to work towards more effective caching of stuff like this but it's going to take time ...

Dirk: the timezone calculations shouldn't be done in the query because it's probably being calculated for every bleepin' row, knowing how brain-dead Oracle can be.  Since they're calculated on bindvars they're constant values for the duration of the query ...