Imporve SQL Preformance

  • Avoid the use of WHILE loop
  • Use UNION ALL instead of UNION whenever is possible
  • Avoid using the joins of multiple tables in the where and join ine the from clause
Read More

Difference between queue and topic

Queue Topic
The point-to-point or queue model works by the sender to receiver setup Publish/subscriber or topic model works by bulletin setup
Acknowledgement of the identity of the receiver and oftentimes the sender Anonymity in the identities of both the subscriber and publisher
Only allowed one recipient Multiple recipients
The sender and receiver do not have to be both active at the same time Timing is very vital
The sender will receive a notification when the message gets to the receiver Not notify you with such, and there is even a risk that you will have no subscribers
Read More