I did not work in any scenario, as you have here. However, in the past I discussed a similar problem, and here is the outcome of the discussion. (Although, I admit, I have never seen an implementation). In addition, I am afraid that there cannot be a simple direct solution.
Assumptions:
I am. The data to be recorded is sorted.
Decision:
I am. Fragment the data warehouse into multiple files. Highlight a range of sorted values for each file. eg. write 1-10000 to file 1, write 100001-20000 to file 2, etc.
II. When you write / read data, you know the range in front of your hand so you can meet point 2.
III. He will also decide clause 3 if the likelihood that two or more processes request the same data is less.
To provide a more accurate solution, we need more information about what you are trying to achieve.
source share