Thank you for the great tutorials ... in this video you select paginated records based upon ID (the primary key), and then sort. Often users want the entire DB sorted, and then paginated. Could you comment on this? How does one sort an entire DB in a reasonable amount of time, if the DB is large. How does one avoid "missing" existing (not new or deleted) records, when records and be deleted or added to the DB?
If you have a database that is frequently updated, it seems like this method of pagination could "miss a record". For example, if you get records 1-5, then record 3 is deleted, and you get the next set of pages, pages 7-11 would be returned. Is this true?
Thank you for the great tutorials ... in this video you select paginated records based upon ID (the primary key), and then sort. Often users want the entire DB sorted, and then paginated. Could you comment on this? How does one sort an entire DB in a reasonable amount of time, if the DB is large. How does one avoid "missing" existing (not new or deleted) records, when records and be deleted or added to the DB?
If you have a database that is frequently updated, it seems like this method of pagination could "miss a record". For example, if you get records 1-5, then record 3 is deleted, and you get the next set of pages, pages 7-11 would be returned. Is this true?
No..... Check queries generate in console.