public inbox for [email protected]  

help / color / mirror / Atom feed

From: Alexey Borzov <[email protected]>
To: Marc G. Fournier <[email protected]>
Cc: Dave Page <[email protected]>
Cc: [email protected]
Subject: Re: Inadequate hosting for www.postgresql.org?
Date: Wed, 03 Nov 2004 00:32:32 +0300
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <E7F85A1B5FF8D44C8A1AF6885BC9A0E4306F1E@ratbert.vale-housing.co.uk>
	<[email protected]>
	<[email protected]>
	<[email protected]>
	<[email protected]>
	<[email protected]>

Hi,

Marc G. Fournier wrote:

> 'k, I just looked at your mirror.php script .. and realized that its not 
> the main web site thats the problem, its your new site ... why is your 
> site so much slower to load up with lynx then the site that is there 
> now? http://www.postgresql.org comes up instantly, 
> http://www.alexey.beta.postgresql.org/index.html.en takes forever to 
> load ... why?

That's easy: www.postgresql.org is static HTML, alexey.beta is dynamic.

I added profiling information to the pages (look at the bottom, only the index 
page has a full set of "markers") and the results are the following: ~80% of the 
page generation time (which is 3+ seconds!) is spent loading local files and 
parsing and executing PHP code. Database access is actually *very fast*. DB 
connection is slow, but that takes only ~10% of time and can be fixed by using 
persistant connections.

That also answers the question why current generation scripts work in acceptable 
time.

BTW, may there be some problems with local file access on this setup?

Dave may test the same on wwwdevel if he copies
system/handler.php
system/page.php
system/page/news-and-events.php
from alexey.beta's webroot to wwwdevel, though I doubt the results will have any 
significant difference...

> I can actually get coffee waiting for your site to load in my browser 
> here, where there is almost zero delay loading the current site ...

OK, here is the answer: the box alexey.beta is upon is only capable of serving 
static content. It chokes on even moderately dynamic one. Buy some real 
hardware, it's not that pricey now.

view thread (60+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: Inadequate hosting for www.postgresql.org?
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox