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.