X-Original-To: pgsql-www-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 496E83A413E for ; Tue, 2 Nov 2004 21:33:46 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 02822-07 for ; Tue, 2 Nov 2004 21:33:35 +0000 (GMT) Received: from ngate.rdw.ru (mail.rdw.ru [195.42.172.4]) by svr1.postgresql.org (Postfix) with ESMTP id 2DFAA3A40F7 for ; Tue, 2 Nov 2004 21:33:34 +0000 (GMT) Received: (qmail 19110 invoked by uid 50004); 2 Nov 2004 21:33:34 -0000 Received: from 192.168.0.57 by ngate.rdw.ru (envelope-from , uid 100) with qmail-scanner-1.23 ( Clear:RC:1(192.168.0.57):. Processed in 0.048176 secs); 02 Nov 2004 21:33:34 -0000 X-Qmail-Scanner-Mail-From: borz_off@cs.msu.su via ngate.rdw.ru X-Qmail-Scanner: 1.23 (Clear:RC:1(192.168.0.57):. Processed in 0.048176 secs) Received: from senoval.rdw.ru ([192.168.0.57]) (envelope-sender ) by ngate.rdw.ru (qmail-ldap-1.03) with compressed SMTP for ; 2 Nov 2004 21:33:34 -0000 Received: (qmail 21388 invoked from network); 2 Nov 2004 21:33:34 -0000 Received: from ppp01.rdw.ru (HELO [192.168.0.7]) ([192.168.0.7]) (envelope-sender ) by senoval.rdw.ru (qmail-ldap-1.03) with SMTP for ; 2 Nov 2004 21:33:33 -0000 Message-ID: <4187FCF0.8020505@cs.msu.su> Date: Wed, 03 Nov 2004 00:32:32 +0300 From: Alexey Borzov User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7.3) Gecko/20040910 X-Accept-Language: ru, en-us, en MIME-Version: 1.0 To: "Marc G. Fournier" Cc: Dave Page , pgsql-www@postgresql.org Subject: Re: Inadequate hosting for www.postgresql.org? References: <41878616.70705@cs.msu.su> <20041102114746.R33702@ganymede.hub.org> <4187E864.5000703@cs.msu.su> <20041102163552.X82047@ganymede.hub.org> <20041102164614.I82047@ganymede.hub.org> In-Reply-To: <20041102164614.I82047@ganymede.hub.org> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200411/28 X-Sequence-Number: 5759 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.