Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-28-2026 03:52 AM
Hi @faruko ,
You can split split initial load using partitioned reads. We did that approach in one of projects. So instead doing something like this:
SELECT * FROM large_tableYou can do that:
SELECT *
FROM table
WHERE id BETWEEN 0 AND 1,000,000With that approach you can even stop and resume loading process if you implement it correctly. Also, the best time to load data initially from database is at night where there is limited number of active users/queries.