I get Ten's frustration since people who didn't know any better keep saying the same things addressed already.
QUOTE(ehbiwtf @ Nov 6 2022, 07:32)

If index is too big, would it not be more manageable to separate it by year, range of years, by category, or hell by both? Users would be forced to only search within a specific date range and/or category every time they hit that search button.
Pages are so important. I think sacrificing other features should have been thought of first. Either way whatever happens, thank you for keeping this website going. PPL might seem really angry and say nasty stuff, and I'm not trying to excuse their behavior--lot of ppl deserve a ban that went too far, but I hope you don't take their passionate responses too personal.
We all appreciate the work you do.
It is not a date range, it is a date jump. It does what page jumping does but by date. Jumping by specific date makes more sense than a random page number because the contents of page numbers change day by day. Remembering what page something is doesn't work well, galleries get pushed down every single day. You all just got used to that clunky mindset because we haven't had a date filter for around a decade, but now it's back as page jumps.
Also, I think you misunderstood what sacrificing it was. It wasn't a multiple choice of selecting which feature to sacrifice, the pagination system had to be axed because it is the one killing the server.
QUOTE(cucamorais @ Nov 6 2022, 08:14)

I don't wanna believe there's no workaround on this, there must be a way to conserve page numbers and RAM at the same time.
If you know how limit/offset and cursor paginations work, you should know there isn't any workaround in it. That page numbering is what's killing the servers. It isn't ideal to paginate big data tables with multiple filters and high traffic that are sorted by most recent date because page contents will keep changing. Another issue was that page content caching keep missing some galleries between pages, which either goes missing or duplicate between 2 pages. The compromise is not having that whimsical blind page jumping to be able to lighten the sever load and display 100% of the results at the same time, not missing any gallery as users flip through the list.
QUOTE(kaliningradh @ Nov 6 2022, 08:16)

The new "jump/seek" option is a bit better as a temporary bandaid but definitely inferior to the pagination we had, it's not user friendly and should have been a file search option filter from the beginning, not a mean to replace what works perfectly fine.
I like to discover new doujins, as such i often need to go forward or backwards a few pages and i can rarely remember the date (but i do remember the page number because it's shorter).
So bring back pagination please, this is such a crucial part of an archive that it shouldn't even be cause for a debate.
Ten already said it: It is a tradeoff. The site will not be able to take the load in the near future and the size of the db doesn't work for pagination anymore. The bandaid was caching the page results which is actually bad because of the reason I said above: galleries keep getting either missing or duplicate between pages due to the high amount/frequency of new entries getting uploaded within a span of minutes. You can discover new doujins using the page jumps as well, and as I said before remembering the page number is useless because contents keep getting pushed back frequently. Remembering the dates or dates ago is better since the dates of entries will always be the same.
This post has been edited by sakuracircle: Nov 6 2022, 12:18