April 2, 2007 at 5:19 am
We probably could use BCP and realize some performance improvements, definately. However, we're finding the performance is more than adequate, we've got it in Production as well as having tested it to a fair thee well, and the amount of code on both sides of the equation, the app server & the database, is a lot less than implementing a bcp solution would be. It really is working. Don't get me wrong. I don't see it as a magic bullet. It merely fills our needs well and could fill others needs under similar circumstances. As usual with databases, it depends.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing post 16 (of 16 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy