I have a very basic communication software that uses database to save messages entered by PC1 and PC2 uses the same database to read these messages and vice versa. My problem is, I need a technique so that I can keep checking the database for new messages. Or I need something that invokes a method to download the message when new record is inserted in the database. At the moment I use a timer which checks the DB every minute regardless of a new record being inserted. I'm looking for a more efficient way to perform the same task.
Any suggestion is welcome.
Thank you