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.
43 questions
1
vote
1
answer
127
views
Should pagination metadata like totalCount be included in the ETag for cached paginated API responses?
I am currently rethinking my API response schema and caching strategy while implementing ETag-based caching for a paginated REST API (for example, listing places).
Each paginated response looks like ...
- 19
2
votes
2
answers
441
views
How to handle pagination logic in a layered architecture without making premature decisions?
I'm working with a layered architecture and I'm unsure where to place the pagination logic. This answer suggests that it's not a domain concern, which I think makes sense. In most cases, pagination ...
- 270
-2
votes
1
answer
359
views
What is the best way to cache paginated data when any page can be moved to and page size is changeable?
I have a React Redux web app that fetches data from an Express/Node backend and MySQL database. I have a table of records that I fetch and store in redux as an array of objects, which I display as a ...
- 11
0
votes
1
answer
544
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 query ...
- 139
2
votes
2
answers
3k
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 ...
- 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 ...
- 113
2
votes
4
answers
2k
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.
...
- 471
1
vote
1
answer
196
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 ...
- 121
1
vote
1
answer
683
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 ...
0
votes
1
answer
82
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 ...
- 109
1
vote
0
answers
312
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 ...
0
votes
2
answers
271
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 ...
- 349
1
vote
1
answer
321
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 ...
- 21
0
votes
0
answers
652
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....
1
vote
2
answers
229
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 ...
- 111
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 ...
- 111
0
votes
1
answer
769
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 ...
- 115
2
votes
2
answers
2k
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
content:[...
- 161
8
votes
4
answers
3k
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 ...
- 191
3
votes
4
answers
6k
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 ...
- 139
16
votes
5
answers
19k
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 ...
- 291
15
votes
2
answers
21k
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?...
- 259
1
vote
2
answers
113
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 ...
- 177
1
vote
0
answers
122
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 ...
- 4,308
3
votes
3
answers
318
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 ...
- 143
0
votes
1
answer
97
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 ...
3
votes
1
answer
369
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 ...
- 161
7
votes
1
answer
652
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 ...
- 422
3
votes
0
answers
2k
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 ...
1
vote
0
answers
99
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 ...
- 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 ...
- 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 ...
- 389
0
votes
2
answers
464
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 ...
6
votes
2
answers
13k
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 ...
- 311
1
vote
1
answer
835
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 ...
- 113
3
votes
1
answer
2k
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 ...
- 581
8
votes
2
answers
9k
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 ...
- 419
1
vote
0
answers
101
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 ...
- 271
6
votes
5
answers
16k
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 and ...
- 161
14
votes
3
answers
18k
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 ...
- 355
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 (...
- 141
11
votes
4
answers
5k
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 ...
- 211
12
votes
3
answers
3k
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 ...
- 1,517