Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-19-2024 02:36 AM
Multiple things.
- First very obvious thing: "5000000" - It's not surprising that you run OOM when loading such a huge amount of records.
- The DBR has a built-in MySQL driver, use it instead
- Use fetchSize to control the number of records. Start e.g. with 1000 and measure the performance. Adapt it if needed
- If the source table has a partition column, use it as described here.