[horde] php and postgres, Re: Horde 3.1, memcache sessionhandler, sidebar, and flock() (fwd)

[Chris Stromsoe]

On Thu, 4 Jan 2007, James MacLean wrote:
> Chris Stromsoe wrote:
>>
>> I just tested with 5.1.6 and the problem is not there.  It feels a 
>> little slower than logging in with 5.2 + my work-around, but it's still 
>> seconds to log in, rather than 10+ minutes.  Before reporting this as a 
>> bug, can anybody else confirm that reverting to 5.1.6 fixes the 
>> behavior?
>
> Just wanted to chime in that this was what we also found here with MySQL 
> as the backend. Key for us was that once the size of the return set got 
> big enough, it appears that PHP would hang most times with PHP 5.2. 
> Testing the same return set against PHP 5.1, it would return, just much 
> to slow to be useful.

I altered the DataTree SQL statements, using the DataTree changes from 
HEAD.  Look at the differences for revision 1.219 and 1.220 at 
<http://cvs.horde.org/framework/DataTree/DataTree/sql.php>.  It made an 
enormous difference in query speed for me.  I've got roughly 13k calendars 
and ~ 20k+ task lists, and the changes to multiple simple queries for OR 
operations made the applications much more usable.


-Chris