Help Center/ ROMA Connect/ User Guide (ME-Abu Dhabi Region)/ Troubleshooting/ Composite Data Integration Tasks/ Speed of Writing Data to DWS Becomes Slower

Updated on 2024-07-10 GMT+08:00

View PDF

Speed of Writing Data to DWS Becomes Slower

Cause Analysis

If the time required for writing data is at the second level, it is normal. If it takes more than 5 seconds to write thousands of data records, the performance deteriorates.

Solution

If a DWS table is frequently accessed, the write performance deteriorates. In this case, contact DWS engineers for optimization. For example, periodically use the analyze plan table and VACUUM FULL.

Parent topic: Composite Data Integration Tasks

Previous topic: FDI Task Fails to Be Executed Because DWS Changes to the read-only State

Next topic: Data Sources

Feedback

Was this page helpful?

Helpful Not helpful

Provide feedback

Thank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.

The system is busy. Please try again later.

Which of the following issues have you encountered?

Content is inconsistent with the product UI

Unclear descriptions

Lack of examples or code

Incorrect steps

Can't find what I need

Lack of best practices

Feedback (optional)

0/500

Select at least one type of issue, and enter your comments or suggestions.

Enter a maximum of 500 characters.

Submit Cancel

For any further questions, feel free to contact us through the chatbot.