[kronolith] performance on large systems

[John Madden]

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

I looked at the code for this and it's really quite a mess -- a standard 
driver for sharing across all Horde components is a great idea until you 
need to optimize it for particular use cases.  Worse, the bigger queries 
are running really big JOINs that take the bulk of the execution time. 
I'm thinking the driver will have to be written to somehow avoid those 
or at least reduce the number of rows involved before the JOIN happens.

John



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