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
- 5384 Views
- HCL, I also Faced
- E-Mail Answers
Answer / 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 |
How do we rollback the table data in SQL Server
Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?
What is the difference between ROW_NUMBER and Ranking function in SQL SERVER?
How many types of subqueries are there in sql server?
What are different types of statement?
do you know what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration
How sql server executes a statement with nested subqueries?
What are the difference between primary keys and foreign keys?
What is the difference between NOROW and LOCKROW?
1 Answers Accenture, Honeywell, Satyam,
How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?
What is etl - extraction, transformation, and loading?
Explain trigger and trigger types?
-
Oracle (3253) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
