---
title: "Discussion on \"Efficient Pagination notes\" | Hashnode"
description: "Discussion on \"Efficient Pagination notes\". Offset pagination and its problems\nYou may have seen requests looking like https://api.example.com/posts?limit=10&offset=50. This is offset pagination. We are saying skip 50 rows and give me the next 10.\nSELECT * FROM posts\nLIMIT 10 OFFSET 50  -- \"sk..."
url: "https://hashnode.com/posts/efficient-pagination-notes/676e66b60d6151968f39f7f1"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [Efficient Pagination notes](https://tigerabrodi.blog/efficient-pagination-notes?utm_source=hashnode&utm_medium=feed)

Offset pagination and its problems You may have seen requests looking like https://api.example.com/posts?limit=10&offset=50. This is offset pagination. We are saying skip 50 rows and give me the next 10. SELECT \* FROM posts LIMIT 10 OFFSET 50 -- "sk...

Dec 27, 2024 · 2 min read · tigerabrodi.blog  
Read the article

-   [#web-development](https://hashnode.com/tag/web-development)
-   [#backend](https://hashnode.com/tag/backend)
-   [#performance](https://hashnode.com/tag/performance)
-   [#databases](https://hashnode.com/tag/databases)
-   [#apis](https://hashnode.com/tag/apis)

## Written by

[Tiger Abrodi](https://hashnode.com/@tigerabrodi)

@tigerabrodi · Germany

  
[View profile](https://hashnode.com/@tigerabrodi)

Obsessed with crafting software.

Just a guy who loves to write code and watch anime.

## Responses

Markdown supported · ⌘↵ to post

No responses yet.