I use ALS 8.0, ADT Table, Visual basic 2005 expres edition


on one of my table I define an trigger (trigger type-AFTER, event
type-UPDATE):
UPDATE TableName SET some_field='p'
WHERE sum=pay

When record in this table is update from my app, it takes few seconds
to execute this operation

Any suggestion