databases, optimization and open source

[Ben Pfaff]

Mark Szidik <szidikm@mlc.lib.mi.us> writes:

> I was so disgusted with the wait that I got the table layout and wrote
> my own Python script to format the data into SQL insert
> statements.  I setup transactions for every 1000 records.  My latest
> load of 100K records took only 2 minutes 17 seconds!

I bet you could double the speed again if you moved from INSERT
INTO to COPY IN.  Congratulations on the speed win though.