[horde] Database performance problem with Horde3/IMP4 with a large user base

[Chuck Hagenbuch]

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.

-chuck

-- 
"we are plastered to the windshield of the bus that is time." - Chris