[horde] php and postgres, Re: Horde 3.1, memcache sessionhandler, sidebar, and flock() (fwd)
Chris Stromsoe
cbs at cts.ucla.edu
Thu Jan 4 04:48:39 PST 2007
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
More information about the horde
mailing list