OData / OData/odataorg.github.io

Paginationation in odata

Open
#317 0 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Dominant language
HTML
Stars
73
Forks
106
PR merge metrics
No merged PRs in 30d

Description

HI,
i am using skip for pagination.
but what i observed that my table contain 1000 rows and page size is 10 .
response getting only 10 rows that is fine. but sql giving all 1000 records then odata return only 10 records .
so how we reduce this sql load as sql also to give only 10 rows

Contributor guide

No contributing guide indexed for this repository

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

No file, test, or entry point is identified in the issue. Start by locating the OData pagination implementation and any tests covering skip and page size 10, then determine whether the reported SQL behavior is handled in this repository. Done requires a reproducible case and a documented or tested result for limiting database work to the requested page.

Written by the indexing model from the issue text.

Assessment

Domain
api, database
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.