804
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
this post was submitted on 07 Mar 2026
804 points (100.0% liked)
Technology
82414 readers
2858 users here now
This is a most excellent place for technology news and articles.
Our Rules
- Follow the lemmy.world rules.
- Only tech related news or articles.
- Be excellent to each other!
- Mod approved content bots can post up to 10 articles per day.
- Threads asking for personal tech support may be deleted.
- Politics threads may be removed.
- No memes allowed as posts, OK to post as comments.
- Only approved bots from the list below, this includes using AI responses and summaries. To ask if your bot can be added please contact a mod.
- Check for duplicates before posting, duplicates may be removed
- Accounts 7 days and younger will have their posts automatically removed.
Approved Bots
founded 2 years ago
MODERATORS
Yeah, you can do pagination, but you need two request : one to select everything, the second to only return the results between id x and id y. Needless to say, the performances are far from ideal.
But in recent version you do skip and take x, which is far easier to write. But my codebase date back to the 2000's, and it uses the old ways.
As an example, an SQL request to filter on an handful of parameters, and paginate, easily amount to 40-50 lines of SQL. And that's the easy ones, because some request uses multiple view, in which case I wouldn't be surprised to find a request doing more than 100 lines of SQL, maybe without even factoring the view in.
That's some funky code, pagination is much easier than that, unless there's something else going on.
Probably, but I won't touch that shit unless I have no way doing otherwise.