Take the 2-minute tour ×
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. It's 100% free, no registration required.

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..

Thanks,

Nitesh Kumar

share|improve this question

migrated from stackoverflow.com 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
2  
Please have a look at this article: SQL Server linked server performance stackoverflow.com/questions/1248753/…. 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

 
discard

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

Browse other questions tagged or ask your own question.