Limit paging size

Authored by Tgr on Dec 6 2017, 8:55 PM.

Description

Limit paging size

Per the DBA recommendation in T164990#3264314 / T168984#3659998,
limit paging sizes to 10 lists / 100 entries at a time.

For most queries this limits the number of rows scanned as well.
getListEntriesByDateUpdated is the only exception: it also scans
entries of deleted lists, which could result in an arbitrary
number of rows scanned. Fixing that is left to a separate patch.

Change-Id: I7c144fabcf5d7510a6b81ca85e623705daf01ccd
(cherry picked from commit 8f11305c7b1e2394e38121157b31e74bd889b360)

Details

Committed
TgrDec 7 2017, 8:48 PM
Parents
rERLS9b2c75012aaa: Improve query plan for getListsByPage
Branches
Unknown
Tags
Unknown
References
refs/changes/14/396114/1
ChangeId
I7c144fabcf5d7510a6b81ca85e623705daf01ccd