Hi.
I have a MFC application which uses MYSQL.
On the main GUI i have several indicators that are updated constantly from the DB.
Lets say for example that one indicator indicates whether a certain DB table is empty or not.
The way im using nowadays is to SELECT COUNT on the table every second.
I think it's not the best way to do it, i just dont know any other.
I wonder if there is a way to retrieve/catch a DB event that for instance, can tell me when a table is not empty anymore and i will then indicate it in my GUI without selecting the table every second.

Thanks for your reply.

At first, you can check up that from select count thing... but, if there is empty then u don't need to this every second , just check when u send a insert query