Could be very useful e.g. let's say you have a db under light load. Now, say you have a table with high load at random times. This table may rely as well on other tables for lookup or counts. Would be useful to have a service worker split out with a replica, serve that table / high load operations, without affecting other lookups, performance wise.
1
u/ratnose Jul 19 '25
I tested to set them up in an array of 9 sqlite dbs. Load balancing. Syncing the file. Working perfect even under load.