Hi,

Is there any penalty involved in calling a POST_EVENT 'whatever' in
every INSERT and UPDATE trigger of each table in the database, even
though I am only interested in being notified on the client side when
5 out of 15 tables actually change ?


Reason: I am using a program which automatically creates the complete
script to create a database (including triggers). I can customize the
script which is being used when creating triggers to include the
POST_EVENT, so that my client program (written in Delphi) will be
notified when one of my lookup-tables changes.

If I change the script to include a POST_EVENT all tables of the
database will now signal a POST_EVENT when they are being updated,
although I only need the 5 lookup tables. If there is no penalty in
calling the POST_EVENT for the 10 other tables, I can leave the
script as is. If there is a penaly involved, I have to make sure only
the lookup tables will get use a trigger script with the POST_EVENT included.

I hope this is clear ...

thanks,
Erik De Laet
E.De.L.Com bvba