Efficient Database Pagination: Comparing Offset and Keyset Strategies
In modern web applications, handling large datasets requires efficient pagination. Developers often face three primary challenges: optimizing query performance for deep pages, ensuring data consistency (preventing "drifting"), and maintaining API simplicity. This article explores the two dominant approaches to database pagination: the ...
Posted on Sun, 19 Jul 2026 17:00:54 +0000 by ThE_eNd
Understanding Table Lookups in InnoDB: Mechanisms and Reduction Techniques
Core Concept: What is a Table Lookup?
In MySQL's InnoDB storage engine, tables are physically organized as B+ Trees built on the primary key (clustered index). Secondary indexes store both the indexed attribute values and the primary key of each matched row. When an execution plan selects a secondary index but the query requests columns absent ...
Posted on Sun, 12 Jul 2026 16:31:19 +0000 by silvercover
Greenplum Database Resource Queue Configuration and Performance Tuning
Overview
Resource queues in Greenplum Database provide workload management by controlling resource allocation for non-superuser roles. Superusers bypass these restrictions entirely, executing queries without queue limitations.
Resource Queue Creation Syntax
CREATE RESOURCE QUEUE queue_name WITH (attribute=value [, ...])
Supported attributes:
...
Posted on Thu, 14 May 2026 05:21:04 +0000 by fragger