It's all a matter of how likely a possibility.

Recipe for disaster? A better recipe would be trying to retrieve all 10 million records to your client in a "static" result...

My harsh opinion on the subject would be that if you read an article like this without considering the effects then that is on you not the article author.

I do...

Well, you could say that about life, in general.  But I the trade-off here is data integrity versus performance.  Wrong data versus fast data.  It is not that close for...

• This reply was modified 5 years ago by  rick-1071254.

Oh, what a recipe for disaster!  Since you are requerying the data every time, you have NO WAY to know if the offset is still valid.  You are going to...