Imporve SQL Preformance
- Avoid the use of
WHILE
loop - Use
UNION ALL
instead ofUNION
whenever is possible - Avoid using the joins of multiple tables in the where and join ine the from clause
Just think about micro things
WHILE
loopUNION ALL
instead of UNION
whenever is possible```
This is a workaround to modify network macaddress.
Create a cron job at reboot.
First, it requires that a developer API key on godaddy at https://developer.godaddy.com/keys.
sudo apt update
sudo apt install postgresql postgresql-contrib
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 |