[kronolith] performance on large systems

[Chuck Hagenbuch]

Quoting John Madden <jmadden at ivytech.edu>:

> Does anyone have any experience on large Kronolith installs?  I'm  
> starting to run through imports of data, getting ready for a soft  
> roll-out at the end of this month and I'm finding that there's some  
> really slow SQL being executed.  Loading the main kronolith page  
> takes in the neighborhood of 4-6 seconds on a fairly beefy pgsql box  
> and that will likely be a show-stopper.
>
> 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.

-chuck