>>Also in our case the tables have lots of extra fields never populated such as
>>cUser_Def1,cUser_Def2, (4 fields). If I don't include them into my insert command, should it be better or it doesn't matter anyway?
>
>Sorry, I missed part about speed. I dunno wich one is faster.
I don't want to create more tests, but once I tested it and found name to be slower.
My goal is to achieve the maximum speed. Currently the process takes about an hour for 4K+ records. I want to achieve the maximum performance.
If it's not broken, fix it until it is.
My Blog