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