Triggering code

[classic12]

I have tested triggers and can get an insert to happen when a table updates.

What I need to do is action some code when a field data changes. i.e.
testdb.status1 changes from 0 to 1 do some code.

I know I can create an app to poll every 5 seconds but am not sure of the
workload on very large tables (50,000 rows) Is there another way to achieve
this?

I have no control over the app that updates the table. So i need some form
of 'listener' to achieve this.

Cheers

SteveW

[Dimon]

MySQL server doesn't support sending messages about data changes in database. Now MyDAC doesn't support this possibility as well. However, we are investigating the possibility of adding this functionality in the future.

To investigate and solve this problem you can find some information on MySQL Message API by the following link: http://forge.mysql.com/wiki/ProjectPage ... essage_API