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
- 4145 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 |
Explain transaction server explicit transaction?
What are the types of containers in ssis?
What is the optimization being performed in oracle and SQL Server?
what are acid properties? : Sql server database administration
Mention the different authentication modes in sql server.
How to create prepared statements using odbc_prepare()?
What is transact-sql ddl trigger?
What is service broker?
How can you hide the sql server instances?
What are data resources?
How many database files are there in sql server 2000?what are they?
why would you call update statistics? : Sql server database administration
-
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)
