Writing Data to DWS Is Slow and Client Data Is Stacked

Symptom

Writing data to 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 method, for example, COPY.

  For details about the import methods, see Data Migration to DWS.

• Increase the concurrent client requests.