Re: very slow when writing query to file - Mailing list pgadmin-support

From Guillaume Lelarge
Subject Re: very slow when writing query to file
Date
Msg-id 1320269133.2145.29.camel@localhost.localdomain
Whole thread Raw
In response to Re: very slow when writing query to file  (boris pezzatti <boris.pezzatti@wsl.ch>)
List 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



pgadmin-support by date:

Previous
From: Henry Drexler
Date:
Subject: Bug, New Column... window, data type typing
Next
From: Guillaume Lelarge
Date:
Subject: Re: very slow when writing query to file