Is it possible to watch a table for changes and define a callback whenever the table is changed? I am trying to implement a mechanism where the client is asking for data every 5 seconds from the server and the server should only return not a null value whenever the data has changed. The problem is that the data is quite complex and is inferred from several tables. Therefore, in order to save processing time, I want to calculate this data and return it only when I know it has changed.
Thanks, Omri