Stack Overflow
Stack Overflow

Questions tagged [data-paging]

72 questions
12
votes
5 answers

Data paging in SQL Server CE (Compact Edition)

I am writing a wpf destop application, and would like to use SQL Server CE as a backend. I'm trying to come up with a good way to do efficient data paging. In SQL Server Express, I can do something like this: Select ID, FirstName, LastName From…
Neil
  • 737
  • 1
  • 8
  • 23
11
votes
4 answers

Is this how you paginate, or is there a better algorithm?

I want to be able to take a sequence like: my_sequence = ['foo', 'bar', 'baz', 'spam', 'eggs', 'cheese', 'yogurt'] Use a function like: my_paginated_sequence = get_rows(my_sequence, 3) To get: [['foo', 'bar', 'baz'], ['spam', 'eggs', 'cheese'],…
orokusaki
  • 55,146
  • 59
  • 179
  • 257
10
votes
1 answer

Custom Query in Spring JPA Repository with Pagination

I have tried implementing JPA Repository with Spring Boot it works fine. Now if i try to implement custom query in interface which extends JpaRepository using @Query Annotation it works fine returns List of beans.(using NamedQuery). Now when i try…
ashish
  • 161
  • 1
  • 6
  • 13
8
votes
4 answers

How does MonogoDB stack up for very large data sets where only some of the data is volatile

I'm working on a project where we periodically collect large quantities of e-mail via IMAP or POP, perform analysis on it (such as clustering into conversations, extracting important sentences etc.), and then present views via the web to the end…
Andrew J
  • 1,951
  • 1
  • 14
  • 16
5
votes
1 answer

NHibernate: How to select the root entity in a projection

Ayende describes a really great way to get page count, and a specific page of data in a single query here: http://ayende.com/blog/2334/paged-data-count-with-nhibernate-the-really-easy-way His method looks like: IList list =…
jonh
  • 233
  • 1
  • 10
4
votes
2 answers

How to update the content inside of Page object from Spring Data without changing the other properties

after querying from the database using the given getAll(Pageable pageable) method from spring data jpa i become an Page object. What I am doing is modifing the content list inside of this Page object but I am getting stuck here is that I dont know…
Ock
  • 1,262
  • 3
  • 18
  • 38
3
votes
0 answers

SQLite Full Text Search with Windowing (Paging) and Snippet / Highlight

I'm using SQLite's FTS module to try to implement a full text search with windowing (or paging as some might call it) of results as well as highlighting of the search hits within each window. As far as I can tell it's straightforward to have either…
Emperor Eto
  • 2,456
  • 2
  • 18
  • 32
3
votes
2 answers

Is there a better way than using DetachedCriteria for pagination?

Sorting and paging with Hibernate's Criteria api comes with a big restriction, it needs to retrieve distinct results from the database. Tools provided by the api like DistinctRootTransformer won't work, because it is applied after retrieving the…
Journeycorner
  • 2,474
  • 3
  • 19
  • 43
3
votes
2 answers

Help ! How do I get the total number rows from my SQL Server paging procedure?

Ok I have a table in my SQL Server database that stores comments. My desire is to be able to page though the records using [Back],[Next], page numbers & [Last] buttons in my data list. I figured the most efficient way was to use a stored procedure…
The_AlienCoder
  • 577
  • 6
  • 19
3
votes
1 answer

Total row count with OFFSET .. FETCH issue

Goal is trivial: get total row count and some data page. When I use OFFSET...FETCH approach to implement paging with total row counting I running into following issue: when we pass some big page number (e.g. we have only 100 rows, but requested 15th…
Eugene D. Gubenkov
  • 5,127
  • 6
  • 39
  • 71
2
votes
2 answers

ASP.net Grid paging with merged rows

I am currently using GridView to display tabular data. I need to merge cells in the first column that have equal values. At the moment I have code in the PreRender event to set the RowSpan property for me, and it's working fine. The problem is I…
Flash
  • 15,945
  • 13
  • 70
  • 98
2
votes
0 answers

OnPagePropertiesChanging event not firing?

…
Maninder
  • 1,261
  • 5
  • 20
  • 34
2
votes
1 answer

Is it possible to implement server-side paging with a WCF Service, NOT a WCF Data Service

I've been experiementing with using WCF and have written a WCF Service to provide the backend for a web site. I've encountered a problem when it comes to implementing server-side paging as all the examples I've found (such as…
GrandMasterFlush
  • 6,269
  • 19
  • 81
  • 104
2
votes
2 answers

Calculating the correct length of string per line with Page X/Y

I got asked a question and now I am kicking myself for not being able to come up with the exact/correct result. Imagine we have a function that splits a string into multiple lines but each line has to have x number of characters before we "split" to…
Ahmed ilyas
  • 5,722
  • 8
  • 44
  • 72
2
votes
1 answer

Server-side paging with WCF OData and GetContinuation() method

I am using the QueryOperationResponse GetContinuation() method to attempt and page through a very large data set read off an odata wcf feed. I am using some OData helper libraries acquired from microsoft. The problem is that the paging process…
Sean Thoman
  • 7,429
  • 6
  • 56
  • 103
1
2 3 4 5