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

Patch attached.  Let  me know if you feel it worthy for inclusion on the 
bug report and I'll clean it up to remove stuff rather than commenting 
it out, etc.  Initial testing shows massive improvements (kronolith page 
loading the week view in ~1-2 seconds vs 5-7 seconds) with sharing 
turned on.  It's a hefty change to the logic so it certainly needs 
someone with a better Horde background to look it over.  It skips over 
the intelligence of Horde's DB agnostics but should work on anything 
that supports joins and sub-selects.

John



-- 
John Madden
Sr UNIX Systems Engineer
Ivy Tech Community College of Indiana
jmadden at ivytech.edu
-------------- next part --------------
A non-text attachment was scrubbed...
Name: sql.php.patch
Type: text/x-patch
Size: 4652 bytes
Desc: not available
URL: <http://lists.horde.org/archives/kronolith/attachments/20091117/fb7a674c/attachment.bin>