I am working on an SQLUpdatePlugin that needs to set a few fields in the document and leave the rest as they were. My plan is to load the old documents from the current searcher and overwrite any fields set from SQL.
What is the best way to load a (potentially) large set of documents by ID? Should I make one query with a list of all IDs? make a separate query for each ID? Is there a cache i can try to pull them from? thanks for any pointers. ryan