Hi folks, I'm wondering about the operation
in context of building a database query on a local database. Say I ask for all documents that user X owns. If this user has tens of thousands of documents, it is obviously quite a large set of IDS that would be returned and then put into a database query. Obviously i would do additional filtering on the table and adding pagination, but the issue still remains that there is a large ID set. I was thinking of streaming these IDs to a temporary table and then performing a join on this table and only then apply filtering, but wondering if there is a better way?