Re: Speeds using a transaction vrs not

Joel Fradkin wrote:
> I wrote a .net program to move my data to postgres (works great on
> SQ_ASCII).
> 
> In fiddling around I tried it using the odbc driver and a transaction
> originally, but converted it to using the .net connectivity but no
> transaction.
> 
> What I found was it moved my database (4 gig in MSSQL) in 2 hours using the
> .net, but 12 hours with the odbc and transaction.

You *are* using transactions, you don't have a choice. Did you do the 
transfer of all 4GB in ONE transaction with the ODBC? Please describe 
the process in more detail.

--  Richard Huxton  Archonet Ltd