There is a trigger defined for INSERT operations on a
table, in an OLTP system. The trigger is written to
instantiate a COM object and pass the newly insterted rows
to it for some custom processing. What do you think of this
implementation? Can this be implemented better?
- 1 Answers
- 4901 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / swapna
Instantiating COM objects is a time consuming process and
since you are doing it from within a trigger, it slows down
the data insertion process. Same is the case with sending
emails from triggers.
This scenario can be better implemented by logging all the
necessary data into a separate table, and have a job which
periodically checks this table and does the needful.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How do you use a subquery to find records that exist in one table and do not exist in another?
What is difference between primary key and foreign key?
What is transaction server implicit?
what is memory-optimized nonclustered indexes
Explain a checkpoint?
What is resource governor in sql server?
How to create “dependant” parameter “make, model, year”
How to run sql server 2005 books online on your local system?
What is dynamic cursor in SQL SERVER?
What is a data source or ds? : sql server analysis services, ssas
What is query processing?
What is normalization of database?
What are the advantages of using a stored procedure?
How to get a list of columns in a view using the "sp_columns" stored procedure?
What are the common performance issues in sql server?
