Joel Fradkin wrote:
Thanks.
I guess I could add that logic, but this is a one time process going to run
the night we go live on postgres.
With .net it took like 2 hours to do the whole shebang, so I am happy.
Fair enough. I tend to produce a text-file and use COPY for bulk
transfers, but that's ju
inal Message-
From: Richard Huxton [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 24, 2005 9:21 AM
To: Joel Fradkin
Cc: pgsql-sql@postgresql.org
Subject: Re: [SQL] Speeds using a transaction vrs not
Joel Fradkin wrote:
> No I did not do it in on transaction (although in .net I never sta
Joel Fradkin wrote:
No I did not do it in on transaction (although in .net I never started or
commited a transaction.
All inserts/updates/etc take place within a transaction with PostgreSQL.
Some client libraries autocommit for you - you'll need to read the
documentation.
ODBC :
myCommand.Comman
pies of the original message, including attachments.
-Original Message-
From: Richard Huxton [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 23, 2005 3:03 AM
To: Joel Fradkin
Cc: pgsql-sql@postgresql.org
Subject: Re: [SQL] Speeds using a transaction vrs not
Joel Fradkin wrote:
&
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 MSS
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 usi
