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 |
|
KingSexy182
Starting Member
7 Posts |
 Posted - 2003-10-16 : 02:30:08
|
| -Can anyone tell me what "-UseInprocLoader" does? I know it improves the performance when applying the snapshot, however i cant find info on this.-If it improves performance, then how come developers have to add this parameter to the distribution agent? why isnt a default?-Is it any different than to not use it apart from the performance issue?-Ive tested, and it does cut the snapshot initialization time almost by half. But im hesitant to use it in a production enviromment because I dont know much about it.regards & thanks |
|
|
KingSexy182
Starting Member
7 Posts |
Posted - 2003-10-28 : 00:52:35
|
| I have found out more info about 'UseInprocLoader'The distribution & merge agent use bcp program,however if 'UseInprocLoader', replication willBULK INSERT instead.anyway, the 'UseInprocLoader' almost halved my replicationtime in comparison to the default settings.thanks anyway. |
 |
|
|
|
|
|
-UseInprocLoader Property