Re: very slow when writing query to file

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