Pagination Optimization: Why Limit-Offset Can Be a Time Bomb and Cursor Pagination as the Solution

Pagination is a technique for dividing database query results into smaller chunks. Using LIMIT OFFSET queries is the most commonly used method. However, this method has several weaknesses, especially in terms of performance on very large datasets. This article will discuss problems that arise when using LIMIT OFFSET and explore more efficient alternatives, such as cursor-based pagination and seek method. ...

August 11, 2024 · 12 min · 2492 words · Muchlis

Profiling Techniques in Golang

Profiling is the process of measuring application performance to identify and analyze various aspects that affect performance, such as CPU usage, memory, and goroutines. Profiling is very important in the development process to ensure applications run efficiently and optimally and to detect anomalies. ...

October 20, 2022 · 6 min · 1247 words · Muchlis at eFishery