X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id D0F4BDA4DF for ; Sun, 16 Oct 2005 19:02:05 -0300 (ADT) 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 59723-05 for ; Sun, 16 Oct 2005 22:02:01 +0000 (GMT) Received: from fmf.vtu.lt (fmf.vtu.lt [193.219.145.206]) by svr1.postgresql.org (Postfix) with ESMTP id C4AF5DA682 for ; Sun, 16 Oct 2005 19:02:02 -0300 (ADT) Received: from fmf.vtu.lt (localhost [127.0.0.1]) by fmf.vtu.lt (Postfix) with ESMTP id 98C9918473; Mon, 17 Oct 2005 01:02:00 +0300 (EEST) Received: from 85.206.197.88 (SquirrelMail authenticated user nso) by fmf.vtu.lt with HTTP; Mon, 17 Oct 2005 01:02:00 +0300 (EEST) Message-ID: <3311.85.206.197.88.1129500120.squirrel@fmf.vtu.lt> In-Reply-To: <4352C113.80104@pse-consulting.de> References: <17260.81.7.89.65.1129382454.squirrel@fmf.vtu.lt> <29778.1129391647@sss.pgh.pa.us> <18133.81.7.89.65.1129392990.squirrel@fmf.vtu.lt> <4351DCB6.3040307@paradise.net.nz> <23627.81.7.89.65.1129460506.squirrel@fmf.vtu.lt> <4352C113.80104@pse-consulting.de> Date: Mon, 17 Oct 2005 01:02:00 +0300 (EEST) Subject: Re: Bytea poor performance From: "NSO" To: "Andreas Pflug" Cc: pgsql-performance@postgresql.org User-Agent: SquirrelMail/1.4.5 MIME-Version: 1.0 Content-Type: text/plain;charset=utf-8 Content-Transfer-Encoding: 8bit X-Priority: 3 (Normal) Importance: Normal X-VGTU-MailScanner-OpenProtect-Information: Please contact the ISP for more information X-VGTU-MailScanner-OpenProtect: Found to be clean X-MailScanner-OpenProtect-MCPCheck: X-MailScanner-OpenProtect-From: nso@fmf.vtu.lt X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.274 required=5 tests=[AWL=-0.100, DNS_FROM_RFC_ABUSE=0.374] X-Spam-Level: X-Archive-Number: 200510/249 X-Sequence-Number: 15017 Well, no. Delphi isn't better, same time just for downloading data... But as I told before, if for ex. pgAdminIII is running on server machine it is a lot faster, I do not know why, I was monitoring network connection between client and server and it is using only up to 2% of full speed.. is server can't send faster? or client is not accepting data faster? > NSO wrote: > >>Hello, >> >> No it is not web app, I tested on simple delphi app and with PGAdmin >>III.. same results.. Query from PGAdmin takes up to 30seconds... >> >> > Displaying the data can take a long time on several platforms for > pgAdmin; complex controls tend to be dead slow on larger data sets. > We're waiting for a better wxWidgets solution, I doubt delphi is better... > > Regards, > Andreas > > > -- > This message has been scanned for viruses and > dangerous content, and is believed to be clean. > > -- This message has been scanned for viruses and dangerous content, and is believed to be clean.