Re: very slow when writing query to file

Поиск
Список
Период
Сортировка
От Guillaume Lelarge
Тема Re: very slow when writing query to file
Дата
Msg-id 1320269133.2145.29.camel@localhost.localdomain
обсуждение исходный текст
Ответ на Re: very slow when writing query to file  (boris pezzatti <boris.pezzatti@wsl.ch>)
Список 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 по дате отправления:

Предыдущее
От: Henry Drexler
Дата:
Сообщение: Bug, New Column... window, data type typing
Следующее
От: Guillaume Lelarge
Дата:
Сообщение: Re: very slow when writing query to file