Thanks for the reply Martin. The information was very helpful and clear. We don't have many inserts in the table.
I needed one clarificaton in the below quote
"Also, the database change notification registration is independent of the connection that created it. It might cease to exist for various reasons, and you won't be notified about it. In one project where we wanted to use it, we had to verify in some intervals it existed and recreate it if it failed. We eventually had to abandon the approach because our tables weren't "mostly read-only" after all. "
How did you verify in the intervals whether its existed or not and recreated it when failed?