Help Center>
ROMA Connect>
Troubleshooting>
Composite Data Integration Tasks>
Speed of Writing Data to DWS Becomes Slower
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
Last Article: FDI Task Fails to Be Executed Because DWS Changes to the read-only State
Next Article: Data Sources
Did this article solve your problem?
Thank you for your score！Your feedback would help us improve the website.