Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have created a linked server in SQL Server 2008 R2 Enterprise Edition for MySQL i.e. MySQL database is accessible under SQL Server environment. I have a created a trigger in SQL Server such that every new entry in the SQL Server object(table) also insert a new entry in the MySQL database object.

The issue here occurs with performance, that is without trigger insert in SQL Server is fast but when trigger is created the insert becomes very flow. The performance is degraded too much.

Please help me how to optimize the performance.

share|improve this question

migrated from Apr 15 '13 at 12:45

This question came from our site for professional and enthusiast programmers.

Thanks but the same issue is with me as I am using INSERT OPENQUERY(MYSQL,'select * from tbl limit 0') select top 1 * from dbo.tbl order by id desc . Any suugestion on this?? – Nitesh Kumar Apr 15 '13 at 11:33
Please have a look at this article: SQL Server linked server performance…. Do you really need to update the MySQL database right away or is some delay acceptable? Do you know if you have a lot of inserts in this table? – KookieMonster Apr 15 '13 at 15:37
Service Broker could be your friend if some delay is allowed. Under normal circumnstances, the delay can be very short. – spaghettidba Apr 16 '13 at 10:27

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.