in reply to Perl to monitor a table in database
If you are using Oracle you can avoid polling the database for changes by writing an insert trigger (or update or delete) and making that issue an alert - see the DBMS_ALERT package. The outside perl script can then just call DBMS_ALERT waitany and it will block for the alerts you registered for.
As others have pointed out, counting the rows added might not be as straight forward if you delete rows as well.
|
---|
Replies are listed 'Best First'. | |
---|---|
Re^2: Perl to monitor a table in database
by pid (Monk) on Oct 27, 2009 at 01:52 UTC |