Hi, I have query like this Select * from tabelname limit 10 OFFSET 10; If i increase the OFFSET to 1000 for example, the query runs slower . The bigger is OFFSET the slower is the query.
This is standard pagination feature i use for my website. Actually the query is little bit more complex than this, but it is generally a select with a join. So i wander if there is a way to speed up this kind of query ? I'm now reading about windowing functions , but I'm not sure this is the way to go for this feature.
