I think this is a good approach and I see a few ways to make it even better. First you could overfetch to reduce risk of needing another query. Secondly you cou

I think this is a good approach and I see a few ways to make it even better. First you could overfetch to reduce risk of needing another query. Secondly you could rewrite ids occasionally to reduce gaps.