ReadMeFeed / Community knowledge

#database-performance

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

Article0 replies3,730 followingPosted 28 Dec 2025, 10:09 UTC28.7K views4,409 votes

FireDAC Array DML: Batching Delphi Inserts to Cut Network Round Trips

Row-by-row inserts in Delphi often bottleneck on network round trips. FireDAC Array DML batches them into a single call, but memory and error-handling trade-offs apply.

Community & Careers · Blog

delphi

Next page →

Tasadduq Burneyowner

Started28 Dec 2025, 10:09 UTC

Level 38Owner34,775 rep points

Community & Careers

Article0 replies3,289 followingPosted 28 Aug 2025, 15:29 UTC95.4K views2,121 votes

Sequelize Pagination with LIMIT and OFFSET: Stable Pages and Predictable Boundaries

Implement stable Sequelize pagination with limit and offset. Learn how to avoid off-by-one errors, fetch total counts separately, and when to switch to key-set pagination for deep pages.

Community & Careers · Guide

sequelize-pagination

nodejs database-performance

Community & Careers

Article0 replies1,984 followingPosted 08 Dec 2025, 14:04 UTC97.9K views3,118 votes

Hibernate Deep Pagination: Offset Costs and Keyset Alternatives

Offset pagination in Hibernate slows as page numbers grow. Learn how keyset pagination avoids that cost, when to use each approach, and how to verify the difference with SQL logging and EXPLAIN ANALYZE.

Community & Careers · Blog

hibernate database-performance

java

Community & Careers

Article0 replies3,827 followingPosted 05 Sept 2025, 08:51 UTC79.2K views2,157 votes

Choosing Between Offset and Keyset Pagination in Hibernate ORM

Compare Offset-based vs. Keyset-based pagination in Hibernate. Learn when to use setFirstResult() and when to implement a Seek Method to avoid database performance degradation.

Community & Careers · Guide

hibernate database-performance

java

Community & Careers

Article0 replies3,456 followingPosted 14 Jul 2025, 19:08 UTC25.1K views2,034 votes

SQLite Write-Ahead Logging: Concurrency and Performance Without Sacrificing ACID

SQLite WAL mode enables concurrent readers and writers without blocking, boosting write throughput while preserving ACID. Covers enabling WAL, checkpoint tuning, pitfalls, and production verification.

Community & Careers · Guide

concurrency database-performance

sqlite

Community & Careers

Article0 replies3,683 followingPosted 10 Jul 2025, 02:02 UTC21.6K views3,226 votes

Optimizing Read‑Heavy Workloads in Azure SQL Database with Read‑Scale‑Out

Learn how to offload read traffic in Azure SQL Database Premium and Business Critical tiers with Read‑Scale‑Out, verify routing, monitor replication lag, and understand the key trade‑offs.

Community & Careers · Blog

sql-connection-strings azure-sql-database

azuresqldatabase

Community & Careers

Article0 replies1,196 followingPosted 22 Aug 2026, 01:57 UTC82K views2,796 votes

Cap and Validate AdonisJS Lucid Pagination Before It Stalls Your Database

AdonisJS 5 Lucid paginate() runs COUNT(*) plus LIMIT/OFFSET. Cap perPage, coerce query strings, and verify query plans before shipping list endpoints.

Community & Careers · Blog

lucid-orm

adonisjs database-performance

Community & Careers

Article0 replies4,596 followingPosted 13 Sept 2026, 03:06 UTC133.6K views2,165 votes

Diagnosing Inconsistent Pagination in Hibernate: setFirstResult and setMaxResults

Learn how to diagnose and fix unstable result sets and performance lag when using Hibernate's setFirstResult and setMaxResults for database pagination.

Community & Careers · Guide

hibernate java-orm database-performance

Community & Careers

Article0 replies4,551 followingPosted 07 Dec 2025, 09:09 UTC39.5K views1,326 votes

Firebird PSQL Stored Procedures: Cut Network Round‑Trips and Keep ACID Compliance

Server‑side logic in Firebird with PSQL can replace costly client loops, cut network traffic, and keep ACID compliance. This post walks through a worked example, compares it to client‑side loops, and discusses trade‑offs.

Community & Careers · Blog

psql

firebird database-performance