Large offset in ELSA query

When wanting to query ELSA with a large offset, we have to use a large limit too (eg. offset: 10000, limit: 10100 to get the 10 000 results to 10 100) which result on a very slow query.

Is it possible to make a faster query with a large offset ?
