[kronolith] performance on large systems

[John Madden]

>> 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?

Hmm.  I disabled sharing and found that the performance issue is the 
same and the SQL statements being executed don't appear to be any 
different.  Is sharing a red herring?  The SQL I sent before seems 
clunky (at best) to me -- why the CASTs and regexps?  Can those be 
eliminated?

John




-- 
John Madden
Sr UNIX Systems Engineer
Ivy Tech Community College of Indiana
jmadden at ivytech.edu