Electric + DB: best pattern for infiniteQuery
Hey, I'm relatively new so wondering what is the most performant pattern if we want to sync a bunch of data required to pages of an infinite query. A simple example, would be, let's say each page of our query has 100 posts. Should we then create a DB Collection per page and as the user scrolls, create extra new collections and say if we are on page 4, then we unsubscribe syncs for pages 1 and 2? Or is there a better pattern?
