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