[kronolith] performance on large systems

[Chuck Hagenbuch]

Quoting John Madden <jmadden at ivytech.edu>:

>>> By large, I mean somewhere in the neighborhood of 500,000  
>>> calendars.  With that amount of data, I'm thinking the regular  
>>> expressions in  queries such as this one are problematic:
>>
>> For that number of calendars, with the current share drivers, you   
>> probably want to turn off calendar sharing entirely. People will  
>> still  be able to share events via invitations, and we're working  
>> on a faster  sharing driver.
>
> Calendar sharing is a pretty critical component of what we're doing  
> (and why we're implementing Horde to begin with).  Is there anything  
> I can do to help?

This is the open bug:
http://bugs.horde.org/ticket/7363

If you have optimized SQL queries for PostgreSQL, it would be great to  
get this sorted once and for all.

-chuck