The problem:

At the moment the /history view displays the full history to the very first operation that was done with the Nurpawiki instance.

This is ok for a log that's not longer than a month or two but becomes a problem on older instances (say 6-12 months).

How to solve it:

Provide newer/older buttons and include entries from the last 30 days on a single page.

Entries might get better distributed to pages if a single page log items are queried so that there's a fixed number of activity_log IDs per page. I.e.,

SELECT * FROM activity_log WHERE id >= 0 AND id < 30 SELECT * FROM activity_log WHERE id >= 30 AND id < 60

etc.

Comment deleted

Mostly done in r338.

There's still a big DB query that slows down page load (Database.query_activity_in_pages). This query should also be limited somehow in order to close this bug.

Last bit done in r341.