Re: very slow when writing query to file

From: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
To: boris pezzatti <boris(dot)pezzatti(at)wsl(dot)ch>
Cc: Fernando Hevia <fhevia(at)gmail(dot)com>, Francisco Leovey <fleovey(at)yahoo(dot)com>, "pgadmin-support(at)postgresql(dot)org" <pgadmin-support(at)postgresql(dot)org>
Subject: Re: very slow when writing query to file
Date: 2011-11-02 21:25:32
Message-ID: 1320269133.2145.29.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

On Wed, 2011-11-02 at 08:58 +0100, boris pezzatti wrote:
> Thank you Fernando for reproducing this.
> I suspect there must be some part of code in the
>
> * for each row
> * for each column
>
> loops that result inefficient only on some machines or OS's (I'm using
> Archlinux).

I'm using Fedora, so we both use Linux.

> In fact the extra time I and Fernando get can not only be attributed to
> adding commas, " and line feeds. The same file which I retrived in more
> than one hour (32Mb), could be saved with openoffice in 10 seconds,
> changing column separators, text delimiters and encoding.
>

Actually, it does.

> Could it be possible that the use of e.g. error catching in the loops
> results in poor performance on some systems? (I'm not a c++ programmer ...)
>

Nope, I don't think so.

--
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com

In response to

Browse pgadmin-support by date

  From Date Subject
Next Message Guillaume Lelarge 2011-11-02 21:26:38 Re: very slow when writing query to file
Previous Message boris pezzatti 2011-11-02 08:21:40 Re: very slow when writing query to file