All Products
Search

This Product

    ApsaraDB RDS:How do I handle the issue that the UPDATE statement is remotely executed on a linked server at a low speed?

    Document Center

    ApsaraDB RDS:How do I handle the issue that the UPDATE statement is remotely executed on a linked server at a low speed?

    Last Updated:Jul 25, 2024

    Problem description

    The UPDATE statement is remotely executed on a linked server at a low speed. However, the SELECT statement can be executed on the linked server at a high speed.

    Causes

    When the UPDATE statement is executed on a linked server, data is transferred to the on-premises server for computing. As a result, the statement is executed at a low speed.

    Solutions

    We recommend that you encapsulate the UPDATE operation as a remote stored procedure and call the stored procedure by using a linked server. You can also use the OPENQUERY function to call the stored procedure. For more information, see OPENQUERY.

    References

    • For more information about the stored procedures supported by ApsaraDB RDS for SQL Server, see Stored procedures.

    Application scope

    ApsaraDB RDS for SQL Server