[horde] Database performance problem with Horde3/IMP4 with a large user base
chuck at horde.org
Fri Apr 28 20:46:22 PDT 2006
Quoting Luc Germain <Luc.Germain at USherbrooke.ca>:
> Did any one tried to implement caching of the sharing permissions in the
> session? Or, has any work been done to try to optimize the database
> structure or requests so the permissions would be faster to read when there
> are tens of thousands of users and shared objects?
The plan is to just move that data out of the datatree system into a
more optimized table structure. There's no specific timeline on that
yet, but it's 99% going to happen.
> If not, is it possible to completely deactivate the sharing of calendars,
> tasks etc, in horde3 so we can avoid making those slow database queries?
You can try setting the DataTree driver to "None". I'm not positive
this won't have negative side effects, but theoretically it should
work and it'd probably be a bug (or bugs) if it didn't.
"we are plastered to the windshield of the bus that is time." - Chris
More information about the horde