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

[Chris Stromsoe]

On Wed, 3 Jan 2007, Chuck Hagenbuch wrote:
> Quoting Chris Stromsoe <cbs at cts.ucla.edu>:
>
>> I've traced the performance problem to the PHP database calls, so it's 
>> probably not a datatree/shares problem.
>>
>> For the first call to exists(), calls to pg_fetch_row() return in maybe 
>> 1/4 to 1/3 of a microsecond (measured using microtime() -- 2 to 3 calls 
>> return with the same time-stamp).
>>
>> For the second call to exists(), between 10 and 16 calls to 
>> pg_fetch_row() return with the same timing characteristics as the first 
>> call to exists(). All of the subsequent calls to pg_fetch_row() take 
>> ~100ms to return.
>
> Still sounds like it could be a memory issue. Also, from the poster 
> having trouble with Turba, there might be a general change in PHP 5.2 
> that affects this. I'm using PHP 5.2, I know that you (Chris) are from 
> earlier posts - do other people out there see a similar pattern?

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?



-Chris