Add tests for paginated queries in the store

[SantiagoPittella]

We need to test that queries that user pagination are working accordingly.

This checks needs a properly seeded DB, since we want to check the size limit for the queries too. Which might be pretty big in some cases.

[SantiagoPittella]

We can leverage the benchmarks binary to test this out while measuring performance instead of adding unit tests. Results can be useful for #1243 . wdyt @bobbinth @Mirko-von-Leipzig ?

[bobbinth]

I think leveraging the benchmarking binary should work. I'm assuming we'd use it to build the "seed" database and then run test against it. Not sure if that's something we should include into the regular testing pipeline as it will probably increase the testing time significantly - but as a set of standalone tests, it could be OK.

[Mirko-von-Leipzig]

An ideal goal would be that we can create such a database and use it for a bunch of integration tests; if its fast enough it could just be an in-memory db created via mockchain for realistic data which would be fantastic..

But ito this issue I think your suggestion makes sense.