[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
(1)
Published on 27 Mar (4 weeks ago) by Alex. Galveia
1 vote
Published on 27 Mar (4 weeks ago) 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.