ging/mailboxer — Issue #18: Database Pagination
Author: karma
Created: 2012-01-20 01:24:24+00:00
State: open

I've already read #17, but after reading it I got the impression that you're talking about array pagination, after obtaining all of the messages from the database.

I have a migration scenario where some users have hundreds of thousands of messages, and so that approach doesn't work. We tried doing it with standard Rails scopes, but the way the queries and indexes are structured results in about 1 minute per query (even with limit scope), which can't be used to paginate (at least on Postgres).

Do you know if such a scenario has ever been tested ?