Skip site navigation (1) Skip section navigation (2)

Re: Inadequate hosting for

From: "Marc G(dot) Fournier" <scrappy(at)postgresql(dot)org>
To: "Gavin M(dot) Roy" <gmr(at)ehpg(dot)net>
Cc: Mitch Pirtle <mitch(dot)pirtle(at)gmail(dot)com>,Dave Page <dpage(at)vale-housing(dot)co(dot)uk>,"Marc G(dot) Fournier" <scrappy(at)postgresql(dot)org>,Alexey Borzov <borz_off(at)cs(dot)msu(dot)su>, Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>,pgsql-www(at)postgresql(dot)org
Subject: Re: Inadequate hosting for
Date: 2004-11-04 00:39:38
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-www
On Wed, 3 Nov 2004, Gavin M. Roy wrote:

> Just offering my 0.02... have you checked to see if the delays are due to 
> heavy io?

From the server side of things, I've checked everything that I can think 
of ... I ran a 'find . -mmin +1 -print | wc -l' on /usr/local/lib, it 
reported back 28k files processed in ~45sec (641files/sec) ... I realize 
that this doesn't simulate what Alexey is doing, but he's only reading in 
a dozen files or so, according to him, for the index page ... is should be 
able to handle that easily enough ...

I even grab'd a recursive directory script off of, so taht I ran 
it thorugh php ... did a stat on all 28k files to get mtime (again, not 
reading in the whole file, only the meta data), but I was getting 
~200files/sec off of that ...

So, the only thing I can think of is a problem with Alexey's code, which 
he swears is impossible ... or a problem with mod_php4.3.9 itself ...

I even drop'd the # of processes on that server by 1/2 this afternoon, and 
there is no noticeable improvement to Alexey's code ...

Marc G. Fournier           Hub.Org Networking Services (
Email: scrappy(at)hub(dot)org           Yahoo!: yscrappy              ICQ: 7615664

In response to


pgsql-www by date

Next:From: Mitch PirtleDate: 2004-11-04 00:47:15
Subject: Re: Inadequate hosting for
Previous:From: Marc G. FournierDate: 2004-11-04 00:28:45
Subject: Re: Inadequate hosting for

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group