Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 4137 Views
- 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 |
Can we use having clause without group by?
Explain different forms of normalization?
How do you check the performance of a query and how do you optimize it?
How to execute function in stored procedure sql server?
Tell me what is the order in which the sql query is executed?
How to turn on the mssql api module in php?
What are various limitations of the views?
What is indexed views? plz explain with example?
Can an entity have two primary keys?
What is the use of DBCC commands?
could u plz explain about joins and views?
Can two tables share a primary key?
-
Oracle (3259) - 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)
