There are a few potential ways to ensure higher perf of queries that would otherwise have large offsets (such as creating a related column to query on so offsets are smaller). Currently doing a search that looks up a common last name such as 'MILLER' with a large offset results in very poor performance (order of 10 seconds in some cases in production). This should be investigated and potentially fixed somehow.
untoldone
commented
10 years ago
There are a few potential ways to ensure higher perf of queries that would otherwise have large offsets (such as creating a related column to query on so offsets are smaller). Currently doing a search that looks up a common last name such as 'MILLER' with a large offset results in very poor performance (order of 10 seconds in some cases in production). This should be investigated and potentially fixed somehow.