With this new system to get (visible OR expunged OR low powered) I have to run 4 querries. They all return different sets:
(expunged==false && low powered==false)
(expunged==true && low powered==false)
(expunged==false && low powered==true)
(expunged==true && low powered==true)
QUOTE(Tenboro @ Nov 2 2022, 04:57)

Index size.
would the old expunged/low-power work if search just run individually on those index and join the result together? For example:
visible, next=X, limit 6, result: A B C D E F
expunged, next=X, limit 6, result: 1 2 3 4 5 6
low powered, next=X, limit 6, result: !@#$%^
expunged && low powered, next=X, limit 6, result: 一 二 三 四 五 六
smashed together, limit 6, result: A1!一B2, next page shall be next=2
QUOTE(ChristofferHanson @ Nov 2 2022, 11:51)

The removal of page numbers is a horrible idea.
I think it's possible if we do page number guesstimate? For example if the lastest GID is 2.000.000 and you have 100 galleries per page then page 50 would start with GID of 2.000.000 - 50*100 = 1.995.000 ? Then if the last gallery shown on this view is GID 1.990.000 it'd say "page 50-55". Since page number is derived for the purpose of display only, maybe done client-side even, it shouldnt cause much load.
This post has been edited by Rephikul: Nov 2 2022, 20:40