A memory-management technique where a computer stores and retrieves data from secondary storage for use in main memory. Memory is divided into equal sized pages so to not waste any memory.
Questions tagged [paging]
2459 questions
24
votes
3 answers
Equivalent of FOUND_ROWS() function in Postgresql
I am doing some paging in my application, returning 20 rows from the database at a time using PostgreSQL's standard OFFSET and LIMIT keywords. For instance, to get page 1 page:
SELECT stuff FROM table WHERE condition ORDER BY stuff OFFSET 0 LIMIT…
Mike Chamberlain
- 39,692
- 27
- 110
- 158
24
votes
7 answers
Paging with Entity Framework 7 and SQL Server 2008
I'm trying to use paging (that is .Skip(...).Take(...) in Entity Framework 7. It works OK with Microsoft SQL Server 2012 and 2014, but fails with the following error on SQL Server 2008:
System.Data.SqlClient.SqlException (0x80131904): Incorrect…
Konstantin
- 251
- 1
- 2
- 5
23
votes
4 answers
Paging of frequently changing data
I'm developing a web application which display a list of let's say "threads". The list can be sorted by the amount of likes a thread has. There can be thousands of threads in one list.
The application needs to work in a scenario where the likes of…
coalmee
- 1,334
- 2
- 16
- 27
22
votes
1 answer
How to transform items in a PagedList?(Android Arch Component Paging Library)
Android Architecture Component now introduced Paging Library, which is great.
According to the official demo The DataSource.Factory now supports map and mapByPage methods, which means we may transform items in one DataSource.
But DataSource and…
landerlyoung
- 1,693
- 17
- 14
22
votes
2 answers
How to implement pagination on a list?
Is there any library that can be used to implement paging for a list?
Let' assume I have a space of 10 lines, and the user can select if he wants to scroll forward or backward by page (thus +- 10 items). This might eg be controlled by -1, 0,…
membersound
- 81,582
- 193
- 585
- 1,120
22
votes
5 answers
Get total row count while paging
I have a search screen where the user has 5 filters to search on.
I constructed a dynamic query, based on these filter values, and page 10 results at a time.
This is working fine in SQL2012 using OFFSET and FETCH, but I'm using two queries to do…
user788312
- 439
- 2
- 10
- 22
21
votes
3 answers
How prompt is x86 at setting the page dirty bit?
From a software point of view, what is the latency between an instruction that dirties a memory page and when the core actually marks the page dirty in the Page Table Entry (PTE)?
In other words, if an instruction dirties a page, can the very next…
srking
- 4,512
- 1
- 30
- 46
21
votes
2 answers
Multi-level page tables - hierarchical paging
Example question from a past operating system final, how do I calculate this kind of question?
A computer has a 64-bit virtual address space and 2048-byte pages. A page table entry takes 4 bytes. A multi-level page table is used because each table…
Bobby S
- 4,006
- 9
- 42
- 61
21
votes
2 answers
Determine page table size for virtual memory
Consider a virtual memory system with a 38-bit virtual byte address, 1KB pages and 512 MB of physical memory. What is the total size of the page table for each process on this machine, assuming that the valid, protection, dirty and use bits take a…
John_D
- 213
- 1
- 2
- 4
21
votes
8 answers
Paging with PagedList, is it efficient?
I have been trying to implement paging for quite a while now and I found this tutorial for paging with MVC: ASP.NET MVC Paging Done Perfectly
Now, in this solution, I query the database for the entire set of clients and then I return a paged list of…
Flame_Phoenix
- 16,489
- 37
- 131
- 266
20
votes
4 answers
How to do page navigation for many, many pages? Logarithmic page navigation
What's the best way of displaying page navigation for many, many pages?
(Initially this was posted as a how-to tip with my answer included in the question. I've now split my answer off into the "answers" section below).
To be more…
Doin
- 7,545
- 4
- 35
- 37
20
votes
7 answers
Difference between virtual page and page frame?
From what I understand pages come from overlays which are clusters of memory spaces generated by Virtual Memory. But I don't understand what frames are or how they relate.
Can anyone explain what page and frame is and how it works?
Callat
- 2,928
- 5
- 30
- 47
20
votes
12 answers
CollectionView move to next cell automatically swift
I am trying to create horizontal slider like Flipkart. I am using collectionView with Horizontal scrolling and paging. Cell contains imageView. I am succeed in scrolling items horizontally manually, but I want all these items to move automatic and…
Riddhi Shah
- 733
- 4
- 11
- 25
20
votes
7 answers
ListView with DataPager not working
From everything I've read, it seemed that adding paging to a ListView control should be dead simple, but it's not working for me. After adding the ListView and DataPager controls to the form and wiring them together, I'm getting very odd behavior.…
gfrizzle
- 12,419
- 19
- 78
- 104
20
votes
2 answers
Get the total number of records when doing pagination
To get a page from a database I have to execute something like this:
var cs = ( from x in base.EntityDataContext.Corporates
select x ).Skip( 10 ).Take( 10 );
This will skip the first 10 rows and will select the next 10.
How can I know how many…
effkay
- 794
- 2
- 17
- 36