1 Answer
- Newest
- Most votes
- Most comments
0
Hello.
This is something that can be addressed for databases in general rather than RDS, but performance can be improved by writing multiple rows at once using BULK INSERT, etc.
BULK INSERT can be executed in a single transaction, which can be faster than executing multiple regular SQL statements.
It also reduces the amount of code written, which leads to a reduction in the burden of data preparation.
Other write and read performance may be improved by changing the RDS storage type to io2, etc.
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_Storage.html
Relevant content
- asked 10 months ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated 5 months ago
- AWS OFFICIALUpdated 3 years ago