Last post Oct 30, 2010 04:55 AM by JohnBrea
Oct 28, 2010 02:41 PM|spmamidi|LINK
Which one is the best MSMQ (process queue data by period intervals) or
Staging Tables (process data by job) or Directly insert into respective table for following scenario
we are receiving the messages from different systems for every 15 minutes and once we receive the message we have to process the message and saves into respective table but volume of messages are very high. I would say two million messages are expected from
all systems for every 15 minutes, Message is very lightweight, it would be in just 600 bytes.
Clients communicating server by using WCF.
Final result should insert the processed message to respective table in all of the above process.
Staging Table: Place a message into staging table once server receives request from client/system and process this table data periodically by using threads in windows services.
MSMQ : place a message in queue once server recieves message from client/system and process the queue periodically by using threads in windows services.
Directly insert into respective table: Process a message and insert into respective table once server recieves message from client/system.
Please let me know which is the best process.
Oct 30, 2010 04:55 AM|JohnBrea|LINK
As you are looking at a vast number of messages, make sure you have enough resources to handle a backlog, should you have a connection problem with SQL for example.
Item 4 at