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
- 5200 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 |
What do you understand by integration services in sql server?
what is isolation level at dead lock?
Why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it?
Explain what is analysis service repository?
Can anyone explain difference between Database, Data warehouse and Data mart with some example?````
When cursors are useful?
what is difference between nchar and char in Sql server ?
What is normalization of database? What are its benefits?
Which is best Subquery (or) joins in sql server? explain why
How to find the version of sql server? : sql server database administration
What is Left Outer Join?
How to truncate a table first before running a package?
-
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)
