Forum OpenACS Q&A: Re: Incredible Performance Decrease - Please help!!!

Collapse
Posted by Don Baccus on
Hmmm...when I tested permissions when I improved their performance I used a large number of objects, around 50,000 or so, and had very acceptable performance.

So, to follow up on my comment above, how much buffer space are you allocating for PG's use?  A 100 bytes per average .LRN object probably isn't too great an exaggeration of space needs.  With the number of objects you have figure on about 20  MB of buffer space minimum, and since there are many non-objects in the system, too, it would be safest to set it far, far larger.

If you enable permission caching (which for .LRN you almost certainly should do, since permissions once set rarely change in .LRN), be sure you allocate enough space to the pool the permissions code uses to cache them.

Caching won't speed a user's first visit to a page, but will greatly speed subsequent visits.