I have a question that is driving me a bit crazy! :s
My C# program that that I am doing connects to a remotely accessed MySQL server on my webhosting company. And it can insert, update, select, delete... You name it.
The problem that I am facing is I want the MySQL DB to send a notification to my C# program whenever a new entry has been added from another computer. Ofcourse I can double check like every 10 seconds whenever the foreign_key has been increased or not, but if I talk about a large scale then this solution is terrible...
What should I do then??