Snapshot isolation?

Bingo.  And there are other solutions with other databases.

And, no, you are incorrect about the problem, which is stated quite clearly in the first sentence of the section labeled,...

ZZartin -

Getting a second page of data is not rerunning a query.  It's getting more data from a single query.  That is what is under discussion in this article and...

Nope, just wrong.  Multi-version read consistency does not introduce phantom rows - it gives a consistent view of data at a single point in time.  Databases are state machines -...

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

ZZartin -

I think this is another example of a basic misunderstanding.  If the result set used to build the pages is different from one set to another, it most definitely...

"Design your system for it"

Whoa, slow down, let's not get all crazy here.  <g>  Violent agreement.

Jeff -

There are other options out there.  Databases that use multi-version read consistency do exactly what you are asking - present an accurate picture of the state of data at...

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, 2 months 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...