Skip to main content
OverflowAI is here! AI power for your Stack Overflow for Teams knowledge community. Learn more

Questions tagged [pagination]

Pagination is a user-friendly way of presenting huge data to the user. Generally, data is divided into a number of pages and a numbered links of all pages is shown for better navigation. Recently, instead of pagination, infinite scrollers are used.

Filter by
Sorted by
Tagged with
0 votes
1 answer
265 views

Efficient API pagination with external authorization service?

Let's say we want to return a paginated list of document id that a user can view. In DB, we have: doc_id user_id ABC user_1 def user_1 ... ... We use an external authorization service, so we can ...
janetsmith's user avatar
2 votes
2 answers
1k views

Improve performance for HTTP Request with huge body

I'm struggling to understand how to improve the performance for an HTTP Request that comes with a huge body. Now, let me explain better what I mean with performance! Imagine I have a DB with the table ...
Jolly's user avatar
  • 123
1 vote
1 answer
2k views

DDD, Aggregates and paginate collections (specific case)

I want to apply DDD to a pet project and everything fits perfectly except for one part: aggregates with collections and the need of pagination. I've been researching about how to deal with an ...
ainsausti's user avatar
  • 113
2 votes
4 answers
1k views

How do I avoid tightly coupling one microservice to another microservice's feature that depends on specific views of the first's data?

I've seen this problem in a few different contexts now but I'm not sure what it's called or how to think about it. Suppose I have a service, AccountService, that serves accounts from a database, e.g. ...
Andrew Cheong's user avatar
1 vote
1 answer
140 views

How to segregate blog posts into seen and unseen?

Imagine an app like Instagram/Reddit with a feed of posts. Problem: We want to show users posts they have not seen before. When the user first opens the app, we retrieve 30 latest posts from the ...
code's user avatar
  • 121
1 vote
1 answer
458 views

API pagination with external or centralised authorization

I am building a REST API which would power a front end as well as other 3rd party apps and hence I want it to be as "standard" as possible. Right now, I am trying to stick to HATEOAS. The ...
Sayak Mukhopadhyay's user avatar
0 votes
1 answer
65 views

Remember initial order of list while editing it

The table Let's say we are running a webapplication for the Superhero Association. In there, there is a table of 1 000 000 super villains which need to be watched. Everytime a super hero gathers new ...
sevic's user avatar
  • 109
1 vote
0 answers
219 views

Paginate large data and store in temporary table for navigation

I have implemented pagination using SQL and stored that result of search into temporary table. Temporary table is named after unique tab id. So that other tab can have seperate result sets. That ...
Anonymous Creator's user avatar
0 votes
2 answers
207 views

Normalising pagination regardless of the target source

I have a service that fetches data from a target source (not through an API but via scraping) which can change. I want to do pagination so that I return 35 items per page but the target source is 25 ...
Alexander Hunt's user avatar
1 vote
1 answer
272 views

How to handle or design review system with pagination?

In typical online review system if any user give review on specific post or others thing, then when that user view that post his review show first. The perfect example of this is Google Play Store. If ...
Rhidoy's user avatar
  • 21
0 votes
0 answers
529 views

How to handle server side pagination + processing large sets of data

So lets say I have a SQL query made by a server that fetches up to thousands of records at a time and I need to display those records in a grid(similar to AG Grid) on the client for the user to review....
Aman Saran's user avatar
1 vote
2 answers
198 views

Grouping search results on a map

I am building a mobile app which lets users search for POIs around them on a map. I am curious to know what would be the best way to "group/paginate" these results in order to avoid downloading ...
Balázs Vincze's user avatar
1 vote
1 answer
1k views

How to do pagination while page gets populated dynamically

I have a page where I list some products based on search data. The products shown are not saved in local database, but are taken live using API (and this is how it has to stay). When page loads, it ...
DonJoe's user avatar
  • 111
0 votes
1 answer
645 views

Exceeded limit for API pagination

I'm implementing an API with pagination which has max_results that can be specified by the client. The server will have a hardcoded limit, for example 100 results per page. In the situation when the ...
erkfel's user avatar
  • 115
2 votes
2 answers
1k views

Is it RESTFul for an endpoint without a path parameter to always have a single resource as a result?

While creating tools for an api, I've noticed the following inside the api specification: GET /cookie-orders returns the following structure as a 200 result: { "first":true "last":false ...
Viktor Baert's user avatar
8 votes
4 answers
2k views

Pagination with API

I'm currently building an opensource administration interface to help people easily manage their contens/websites. Application built on Vue.js and heavily rely on json configurations for which fields ...
Onur Özkan's user avatar
3 votes
4 answers
5k views

Is it possible to cache data on a REST service that returns paginated data?

Under the REST architecture principles, a RESTful application should be stateless, therefore each time I invoke an ASP.NET 4 REST service (with GET verb) that pulls tens of thousands of records, the ...
Rikai no hōhō's user avatar
13 votes
4 answers
14k views

Implementing paging with multiple data sources

I have multiple data sources that I need to search across and return back to the client (web app). For example the sources are: an elastic search index a sql database Is there an efficient way to ...
Prabu's user avatar
  • 261
12 votes
2 answers
16k views

API pagination, how to implement page token paging method?

I am working on implementing an API interface for my project. As i know, there are different forms to make pagination through the results, like the following: https://example.com/api/purchaseorders?...
Karim Harazin's user avatar
1 vote
2 answers
79 views

When to use pagination from database with ajax request

Is there a "rule of thumb" to when it is right to take partial result from a table, rather than the whole table? Consider my current dilemma: SQL view that has total of ~1200 items, the view is not ...
Ziv Weissman's user avatar
1 vote
0 answers
106 views

When virtual scrolling/pagination meets incremental search

I am developing an AngularJS app, and the server side PHP, step by step, implementing features and then polishing them. I currently periodically request data from the server, of the order of a few ...
Mawg's user avatar
  • 4,216
3 votes
3 answers
277 views

How to avoid showing results of page 1 in page 2?

Here's the scenario: I'm showing to the user (let's call him UserA) 10 items per page, ordering them by date (newest first). As UserA still viewing page 1, another user (let's call him UserB) posts a ...
evilReiko's user avatar
  • 143
0 votes
1 answer
81 views

How should I balance memory with network latency on a paginated table?

A web application I'm working on has a tool that queries a database and returns up to several thousand rows. When considering pagination, at what point does it make more sense to get the entire result ...
Chris Olsen's user avatar
3 votes
1 answer
290 views

How does I/O occur for large data files?

Assume that we have a 4GB RAM processor. Let's say we want to play a 4GB movie in VLC player. Now, processor first starts VLC Process and then starts to load 4Gb data. My question is how does this ...
AV94's user avatar
  • 161
7 votes
1 answer
562 views

Implement pagination which memorizes where we left off?

Let's pick a relation database table (say an audit table) with high write rate. We can display 100 records at a time. But as a user don't want to see some the records on page 1 on page 2 when a couple ...
CppLearner's user avatar
3 votes
0 answers
1k views

Realizing pagination for merged array from multiple data sources (APIs)

I'm improving a WordPress theme with PHP. The theme contains a gallery section which loads data from the Flickr API. Now the client wants to display Flickr galleries as well as "local" galleries ...
Julian F. Weinert's user avatar
1 vote
0 answers
61 views

Pagination with multiple groupings

I have a data model that looks like this: Group 1 --Sub group1 ----item1 ----item2 ----item3 --Sub group2 ----item1 ----item2 ----item3 Group 2 --Sub group1 ----item1 ----item2 ----item3 --Sub ...
DavidB's user avatar
  • 107
3 votes
1 answer
1k views

How to paginate local and remote data?

My team is currently facing a problem that we don't know how to tackle. Some technical details: we use Java 8, Hibernate, Spring, MySQL, and AngularJS for the front-end. We need to do pagination on ...
pgs's user avatar
  • 33
0 votes
0 answers
1k views

Managing pagination or cursor with deleting items in the list

I have a REST API that could GET, POST, PUT, DELETE models. My problem is when I paginate that with ajax call combining with DELETE operations. My problem comes after few steps list one page list ...
user237329's user avatar
0 votes
2 answers
442 views

Memory page - virtual or physical and relation to data types allocation?

I'm looking for a understandable definition of memory pages. Please help me clarify the following questions: Is a "memory page" always related only to a data chunk of virtual memory? Are physical RAM ...
TheMeaningfulEngineer's user avatar
6 votes
2 answers
12k views

REST API paging via headers

Let's say I have REST API which provides me list of something and I want to implement paging support - possibility to tell "give me records 20-29 (page 3)". Currently, I don't care about ...
Pavel Štěrba's user avatar
1 vote
1 answer
817 views

MVC, pagination, and massive search criteria

I am currently working on a project that has a fairly large search form - the form is 30 or fields or more. Now I can of course map this out for routing by having my application pull the parameters ...
Ryan Rentfro's user avatar
2 votes
1 answer
1k views

filtering data from db

I've taken over a web application that someone else built. It's a pretty simple application that queries ALL records from a db and displays them in a list. They've also provided a way to 'filter' the ...
dot's user avatar
  • 571
7 votes
2 answers
8k views

how to paginate and combine results that come from different sources sorted

I have the following scenario: I have a user that needs to see some news feeds from different sites and I want to paginate them and sort them by date. The problem is I don't understand how to do ...
arisalexis's user avatar
1 vote
0 answers
95 views

Search results that display in the form of "1 - 20 of about 65" - why the "about"?

I've noticed that Google and large search engines do not display "proper" paging, but display an approximation. For example, I tried to give a specific search on Google to return few results, as per ...
Karl Cassar's user avatar
6 votes
5 answers
15k views

Display large amount of data to client through pagination

I have a web application in which i need to show a big number of data or records for clients. Now i 'll use pagination but i was wondering should I: Load all the data once then pagination, sorting ...
ebram khalil's user avatar
14 votes
3 answers
16k views

What are best practices for caching paginated results whose ordering/properties can change?

What is the best practice for caching paginated search results whose ordering/properties can be changed? Say, in my application, someone wants to see the last 20 discussion threads (out of 10,000). A ...
goodsquishy's user avatar
4 votes
2 answers
1k views

Optimization of a hybrid pagination scheme

I'm working on a Web Application using node.js in which I'm building a partial copy of the database on the client-side to decrease the load on my server. Right now, I have a function like this (...
Kaustubh Karkare's user avatar
11 votes
4 answers
4k views

Does having pagination lessens server load? (theory)

I was wondering what is the reason behind pagination? Is it used because it lessens the burden on the servers since we would technically limit the amount of rows returned per page? I wanted to do ...
Sam Khan's user avatar
  • 211
12 votes
3 answers
2k views

Question on design of current pagination implementations

I have checked pagination implementations on asp.net mvc specifically and i really feel that there is something less efficient in implementations. First of all all implementations use pagination ...
Freshblood's user avatar
  • 1,517