ReadMeFeed / Community knowledge

#database-optimization

Real questions. Useful conversations. Find the people who know your stack.

Article0 replies4,905 followingPosted 10 Jul 2025, 23:08 UTC59K views2,737 votes

Implementing Deterministic Pagination in Knex.js

Learn how to implement stable pagination in Knex.js using limit and offset, and why a deterministic order is critical to prevent data drift and duplicates.

Community & Careers · Guide

nodejs

knexjs database-optimization

Tasadduq Burneyowner

Started10 Jul 2025, 23:08 UTC

Level 34Owner28,025 rep points

Community & Careers

Article0 replies2,212 followingPosted 27 Aug 2026, 23:54 UTC90K views1,308 votes

Stopping the N+1 Leak: Mastering Eager Loading in AdonisJS Lucid

Stop database CPU spikes by eliminating N+1 queries in AdonisJS. Learn how to use Lucid's preload method for eager loading, nested relationships, and constrained data retrieval.

Community & Careers · Blog

lucid-orm

adonisjs

nodejs

Community & Careers

Article0 replies3,288 followingPosted 02 Jan 2026, 19:31 UTC27.3K views4,099 votes

Reducing Index Bloat with PostgreSQL Partial Indexes

Stop indexing your entire table. Learn how PostgreSQL partial indexes reduce storage bloat and improve write performance by only indexing the rows your queries actually need.

Community & Careers · Blog

sql-performance database-optimization indexing

Community & Careers

Article0 replies3,184 followingPosted 09 Nov 2025, 08:08 UTC19.6K views2,129 votes

Solving the Memory Spike: Implementing Efficient Pagination in Hibernate

Stop loading entire datasets into the JVM. Learn how to use Hibernate's setFirstResult and setMaxResults to implement database-level pagination and avoid memory spikes.

Community & Careers · Blog

hibernate

java database-optimization