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?
精彩评论