Hi All,
We've only used MySQL in a very cursory way supporting PHP scripts
running on a server. We now have a requirement to write an application
that shares data using a centralised repository. The application will
be written in Java and we may potentially use MySQL as the data store
using JDBC drivers to bridge the two. One of the key requirements is
that the java application is notified when the data store is updated or
changed such that it can dynamically update its view to the user. Does
MySQL provide anything that may provide for this, is there a standard
way for dealing with this pattern of usage? One solution would be to
continuously query the database, but that seems prohibitively expensive
- particuarly for large data sets.
James