Help Center/ GaussDB(DWS)/ Troubleshooting/ Cluster Performance/ Writing Data to GaussDB(DWS) Is Slow and Client Data Is Stacked
Updated on 2024-01-25 GMT+08:00

Writing Data to GaussDB(DWS) Is Slow and Client Data Is Stacked

Symptom

Writing data to GaussDB(DWS) is slow and the client data is stacked.

Possible Causes

If a single INSERT INTO statement is used to write data to a database, the client may encounter a bottleneck. INSERT is the simplest data writing method and is applicable to scenarios with small data volumes and low concurrency.

Handling Procedure

If data writing is slow, use either of the following methods to rectify the fault:

  • Select another more efficient data import mode, for example, COPY.

    For details about the import modes, see Import Modes.

    For details about the import modes, see "Data Import > Import Modes" in the Data Warehouse Service (DWS) Developer Guide.

  • Increase the concurrent client requests.