ReadMeFeed / Community knowledge

#database-performance

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

Article0 replies2,424 followingPosted 07 Dec 2025, 20:01 UTC135.9K views2,207 votes

Architecting Hibernate Pagination to Prevent In-Memory Exhaustion

Prevent OutOfMemoryErrors in Hibernate by resolving the HHH000104 warning. Learn the two-step fetching pattern to combine JOIN FETCH with database-level pagination.

Community & Careers · Guide

hibernate

dyalog database-performance

Next page →

Tasadduq Burneyowner

Started07 Dec 2025, 20:01 UTC

Level 38Owner35,775 rep points

Community & Careers

Article0 replies3,149 followingPosted 04 Feb 2026, 19:47 UTC120.1K views2,502 votes

Diagnosing and Resolving RocksDB Write Stalls

Learn how to diagnose and resolve RocksDB write stalls by analyzing L0 file accumulation, tuning compaction threads, and adjusting MemTable configurations.

Community & Careers · Guide

lsm-tree database-performance write-stalls

Community & Careers

Article1 reply1 comment4,748 followingPosted 29 Jan 2026, 00:04 UTC45.6K views4,378 votes

owner commented

Stop Joining Tables: Leveraging Index-Free Adjacency in Neo4j

Learn how Neo4j's Index-Free Adjacency eliminates the 'join penalty' of relational databases by using direct pointers for constant-time traversals.

Community & Careers · Blog

graph-databases cypher database-performance

Community & Careers

Article1 reply1 comment1,811 followingPosted 15 Feb 2026, 20:52 UTC104.6K views4,259 votes

owner commented

Stop Loading Entire Tables: Pagination Choices in Rails Active Record

Pagination keeps Rails controllers from loading entire tables into memory. Compare offset pagination with LIMIT/OFFSET to cursor pagination using a stable key, and see how to slice ActiveRecord safely.

Community & Careers · Blog

rails cursor-pagination database-performance

Community & Careers

Article0 replies4,188 followingPosted 01 Oct 2026, 14:02 UTC135.6K views2,539 votes

Firebird Pagination: ROWS, FIRST/SKIP, and the Deep Offset Trap

Firebird does not support ANSI OFFSET/FETCH. It offers FIRST/SKIP and the ROWS clause, but deep pages force the engine to sort and discard rows. Learn how to page efficiently.

Community & Careers · Blog

firebird sql database-performance

Community & Careers

Article0 replies1,787 followingPosted 20 Jun 2026, 15:14 UTC119K views2,465 votes

Routing Read-Only Queries to Azure SQL Database Secondary Replica with ApplicationIntent

Route read-only workloads to a secondary replica in Azure SQL Database using ApplicationIntent=ReadOnly, with notes on consistency, tier coverage and verification caveats.

Community & Careers · Guide

application-intent

azuresqldatabase database-performance

Community & Careers

Article0 replies4,429 followingPosted 19 May 2026, 16:55 UTC12.9K views3,977 votes

PostgreSQL Partial Indexes: Index Less, Write Faster

Partial indexes in PostgreSQL let you index only a filtered subset of rows, shrinking storage and write overhead. Learn when they help, how the planner matches predicates, and how to verify usage.

Community & Careers · Blog

sql-indexing database-performance partial-indexes

Community & Careers

Article0 replies757 followingPosted 07 Mar 2026, 06:49 UTC115.1K views2,185 votes

AdonisJS Pagination: When Offset `paginate()` Is Enough and When to Build a Cursor

Offset pagination in AdonisJS Lucid is trivial but degrades on large tables. Learn when to keep `paginate()` and when to hand-roll keyset cursors.

Community & Careers · Blog

lucid-orm

adonisjs database-performance

Community & Careers

Article0 replies3,917 followingPosted 15 Sept 2025, 20:21 UTC77.4K views2,931 votes

Choosing Between Offset and Cursor Pagination in Prisma

Learn when to use skip/take versus cursor-based pagination in Prisma to avoid performance degradation and data duplication in scalable REST APIs.

Community & Careers · Guide

prisma database-performance pagination