开发者

Use of MSMQ to control SQL write operations

Can I use MSMQ to reduce the number of synchronous write operations to a database and instead have the records written to the database every X number o开发者_StackOverflow社区f minutes?


You can't reduce the number of write operations by queuing them, but you can use a message queue to cluster the writes together.

That might be a bit more efficient (by dint of sharing a single connection), and could also let you schedule the writes at a convenient time if you wanted to ('every X minutes' wouldn't do that, but you could perform the writes during low usage times).

The increased complexity of that arrangement will normally outweigh the benefits - what do you really want to achieve?

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜