Add per_page parameter to index.
Eagerly join articles and users with revisions.
Add indices to foreign key fields.