Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
waterduck
Aged Yak Warrior
982 Posts |
 Posted - 2013-08-10 : 10:55:48
|
| Hi there, i get confuse about this 2 setting. Any clarification are highly appreciated. |------------||OLE SOURCE||------------|||------------||Derived Filed||------------|||-----------------||OLE DESTINATION||-----------------|(Data Flow Component)DefaultBufferMaxRow default value will be 10000. If compare above scenario, will it be 5k row from ole source to derived and 5k row from derived to ole destination?apart from that, rows per batch (OLE DB Destination) by default will be unlimited, if i set to 10k, will it help for performance if i having 1b rows(example)? This is based on assumption that the ole destination will block till all rows are completed and commit it once. Also, are this related to DefaultBufferMaxRow?Any links, clarification, highlights are appreciated. |
|
|
|
|
|
BufferMaxRow vs Rows per batch