CODEWITHSUNDEEP
c#
user584018
user584018

Reputation: 11304

SQL Server Service Broker or Async Window Service?

I have a stage table which is like a queue, data keeps coming to this table.

Can I write a window service runs continuously and read data from queue table and apply some business logic on the records, for this approach could you please share some code link, etc?

Or should I consider SQL Server Service Broker?

Please suggest?

Upvotes: 0

Views: 1166

Answers (1)

Remus Rusanu
Remus Rusanu

Reputation: 294207

If you use a table as a queue, then use a table as a queue. I recommend you read Using tables as Queues.

I do not recommend using Service Broker unless you need activation. Service Broker is designed for distributed applications and comes with significant overhead when compared with a simple queue table (conversations, services and contracts etc).

Upvotes: 3

Related Questions