Questions tagged [paging]

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.

2459 questions
4
votes
1 answer

Recommended way to do paging in mysql when count matters

I have a MySQl suggestion table like this id:int user_id:int item_id:int and I wanted to implement paging for the most suggested items by users. assume each page size is 9. so i have tried select count(id) as total,item_id from suggestions group…
RameshVel
  • 64,778
  • 30
  • 169
  • 213
4
votes
1 answer

Why aren't locked pages counted into the working set size?

The purpose of the VirtualLock WinAPI call is to lock pages into the working set of a process. However, the WorkingSet64 API inexplicably doesn't count those pages. Possibly as a result of this, neither Process Explorer nor the standard Task Manager…
Roman Starkov
  • 59,298
  • 38
  • 251
  • 324
4
votes
1 answer

click event in js datatables (broken with paging)

I want to have a button with js click in each datatable row, but my code is broken by datatables paging system - default datatable option. Click works only on first datatable page. My only idea is to disable paging and create scrolable datatable,…
baron_bartek
  • 1,073
  • 2
  • 20
  • 39
4
votes
1 answer

OFFSET and FETCH causing massive performance hit on a query - including when OFFSET = 0

I have a fairly complex SQL query that involves returning about 20 columns from a large number of joins, used to populate a grid of results in a UI. It also uses a couple of CTEs to pre-filter the results. I've included an approximation of the query…
TheLogicMan
  • 371
  • 4
  • 12
4
votes
1 answer

Paging library call just to LoadInitial after swipe up to refresh, and doesn't call to LoadAfter

I'm trying to create app using Paging library + RxJava, all works fine, it load data from backend and insert it in my Recyclerview, and when i scroll down LoadAfter load next pages normaly, my problem is when i swipe up to refrech data using…
4
votes
1 answer

How to split text into chunks with jQuery

I am trying to split a chunk of text into equal parts so I can do a pager plugin for the text. I want to be able to apply the plugin to a container div without having to specify children like in some other pager plugins; so it could be used with a…
benpalmer
  • 2,057
  • 3
  • 17
  • 21
4
votes
2 answers

Does parent process lose write ability during copy on write?

Say we have a certain parent process with some arbitrary amount of data stored in memory and we use fork to spawn a child process. I understand that in order for the OS to perform copy on write, the certain page in memory that contains the data that…
GamefanA
  • 1,555
  • 2
  • 16
  • 23
4
votes
2 answers

Better way to do result paging in Scala

I do result paging often (given a page number and a page size calculate start, end and total pages) and I ported this little function from Java to help: def page(page: Int, pageSize: Int, totalItems: Int) = { val from = ((page - 1) * pageSize) +…
Ike
  • 763
  • 1
  • 7
  • 17
4
votes
2 answers

Can someone explain this about paging in operating system?

Frequently, on a 32-bit CPU, each page-table entry is 4 bytes long, but that size can vary as well. A 32-bit entry can point to one of 2^32 physical page frames. If frame size is 4 KB (2^12), then a system with 4-byte entries can address 2^44…
4
votes
0 answers

Rad Server - Return high number of records

I am planing to build a Rad server(Rest) project and have some question that I couldn't find an answer. Is there a way to send records to the client as paged by using EMS components if I have millions of record in a table. if not in this case…
Kund
  • 59
  • 6
4
votes
2 answers

Page through S3 objects matching specific filename using boto3

I have an AWS S3 bucket with a Prefix (or "folder") called /photos. That "contains" a bunch of image files and even fewer EVENT.json files. A naive representation might look like…
afilbert
  • 1,430
  • 2
  • 24
  • 25
4
votes
1 answer

How to remember the selected checkboxes between each paging-press

I have a listview with paging. Every paging has 10 rows with with a username, an email and a checkbox. I need to be able to check a couple of checkboxes, in different "pagings", press a button and send an email every to ever user that has been…
user497117
  • 43
  • 1
  • 3
4
votes
1 answer

Why the physical address is same across the runs?

I am running a program with certain array variable. I am taking translating the virtual address(VA) of this array into physical address(PA) using /proc/self/pagemap file which is supported in Linux systems(ubuntu). I tried to observe the VA-PA…
ANTHONY
  • 333
  • 5
  • 18
4
votes
2 answers

Virtual memory without any swap partition

There are few other threads on this subject but I couldn't find a clear answer. On Linux, how can the virtual memory work when there is no swap partition to perform Paging, even no secondary I/O device (HDD, SSD, etc.)? If I take my example: I'm…
kashikai
  • 135
  • 6
4
votes
2 answers

SQL sorting , paging, filtering best practices in ASP.NET

I am wondering how Google does it. I have a lot of slow queries when it comes to page count and total number of results. Google returns a count value of 250,000,00 in a fraction of a second. I am dealing with grid views. I have built a custom…
Aivan Monceller
  • 4,636
  • 10
  • 42
  • 69