We have our own client application, (so no webserver situation). What’s the best method way to know that a table T has been update.
My current solution i have in mind is to have a small “TIMESTAMP_T” with Unique index Of each record of Table T + timestamp field. So whenever I change a record in Table T, I update the timestamp record in table “TIMESTAMP_T” . So then each client is constant polling (every 15 seconds) to see if any record has changed.
select * from TIMESTAMP_T where TIMESTAMP_T.Modified > variableLastTimeILoadedData
So query should be “fast”. Has anyone done something similar thing?
How many clients could be connected in this kind of scenario without bringing down my server? 100? 1000? Assuming I have lastest Quad Xeon servers etc…
Or would you use a different technique? A system where you have your own port and where you have a special simple server app, that I act as a broadcaster and each client that modifies sends a message to that port and he broadcast to every one.