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
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 |