Metadata
- URL: [http://mikehadlow.blogspot.com/2012/04/database-as-queue-anti-pattern.html
- Author: Mike Hadlow
- Publisher: mikehadlow.blogspot.com
- Published Date: 2022-10-04
- Tags: Nx Data Platform Engine
Highlights
- ‘Database As Queue’ anti-pattern.
- Firstly, there’s the polling.
- very efficient at insertions, or updates, or queries, but rarely all three on the same table.
- how you clear records once the workflow is complete.
- deletes are inefficient on SQL Server.
- Fourthly, sharing a database between applications (or services) is a bad thing. It’s just too tempting to put amorphous shared state in there and before you know it you’ll have a hugely coupled monster.