Re: Speeds using a transaction vrs not

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 just me.

> I did convert a fairly large app and it seemed to run faster on the postgres
> box then the MSSQL box, so my first project after actually getting the data
> and views has gone very smooth.

Don't forget to set aside some time for tweaking configuration settings
so you can tune the system.

--
Richard Huxton
Archonet Ltd