[Large List Navigation] Is OFFSET-FETCH the way to go for large data sets?

[Large List Navigation] Is OFFSET-FETCH the way to go for large data sets?

  
Forge Component
(2)
Published on 10 Oct by Alex. Galveia
2 votes
Published on 10 Oct by Alex. Galveia

Hi,


I was wondering if the offset-fetch solution provided by this plugin is the way to go for large data sets. Does any of you have experience in applying it to large data sets? I came across some sites stating that, from a performance perspective, one should favour the "seek method" (see here and here) instead of the "offset-fetch method". Your experience?


Greetings, 

pedro

Pedro Rodrigues wrote:

Hi,


I was wondering if the offset-fetch solution provided by this plugin is the way to go for large data sets. Does any of you have experience in applying it to large data sets? I came across some sites stating that, from a performance perspective, one should favour the "seek method" (see here and here) instead of the "offset-fetch method". Your experience?


Greetings, 

pedro

Follow in discussion

Alex.