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

[Chuck Hagenbuch]

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?

-chuck

--
"we are plastered to the windshield of the bus that is time." - Chris