Received: from moutvdom01.kundenserver.de (moutvdom01.kundenserver.de [195.20.224.200]) by postgresql.org (8.11.3/8.11.4) with ESMTP id g0NKdPl09410 for ; Wed, 23 Jan 2002 15:39:25 -0500 (EST) (envelope-from frank@finner.de) Received: from [195.20.224.219] (helo=mrvdom03.kundenserver.de) by moutvdom01.kundenserver.de with esmtp (Exim 2.12 #2) id 16TUB4-00052z-00 for pgsql-php@postgresql.org; Wed, 23 Jan 2002 21:39:26 +0100 Received: from pd9e5f337.dip0.t-ipconnect.de ([217.229.243.55] helo=finner.de) by mrvdom03.kundenserver.de with smtp (Exim 2.12 #2) id 16TUB3-0004Jl-00 for pgsql-php@postgresql.org; Wed, 23 Jan 2002 21:39:26 +0100 Received: (qmail 31290 invoked by uid 500); 23 Jan 2002 20:39:24 -0000 Message-ID: X-Mailer: XFMail 1.4.0 on Linux X-Priority: 3 (Normal) Content-Type: text/plain; charset=iso-8859-1 MIME-Version: 1.0 In-Reply-To: <20020122225323.D43699-100000@zoraida.natserv.net> Date: Wed, 23 Jan 2002 21:39:24 +0100 (CET) From: postgresql@finner.de To: Francisco Reyes Subject: Re: Long running queries and timeouts Cc: PostgresSQL PHP list , Josh Berkus Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by postgresql.org id g0NKgbm09643 X-Archive-Number: 200201/67 X-Sequence-Number: 871 On 23-Jan-02 Francisco Reyes sat down, thought for a long time and then wrote: > On Tue, 22 Jan 2002, Josh Berkus wrote: > >> Actually, my web developer and I talked about the programming >> necessary >> to do this, and decided that it was easier to break up the >> long-running function into 3 smaller functions. So, no, we don't >> have >> any sample code. In fact, we might be willing to buy some code >> that >> creates a progress bar from someone who does have it ... > > I can't imagine a "progress bar". In particular if you are waiting > for a > reply from the DB server. I found a nice one on http://www.lyrics.de! ;-) It´s just a fake: An animated GIF picture with a progress bar. I think, they made some statistics on database queries, added 10% and created the GIF. The result is, that the waiting time seems shorter. Nice. Correct me anybody please, who can proof that this progress bar is no fake. I´d like to know this technique, too. Greetings, -- Frank Finner And now there is no turning back at all. (M. Moorcock, "Elric Of Melnibone")"