I just looked at some old, which among other things writes to a db. On inspection, the way I was doing things look dumb bordering on insane. Basically, I have a bunch of files which I am processing, and for reasons unknown to me, I decided to break each file up into pieces and add each piece to the db separately, first drop constraints, run copy, then readd constraints. the result is that the process is dominated by ALTER TABLE, which is screwy

I'm thinking that the load process is relatively expensive, and should be batched up if possible. Am I right?

That should have been "old code".

@swasheck what is juniper networks? an ISP?

@Lamak Now all the answers have the username and such as well... stackoverflow.com/questions/24963891/sql-view-with-declare