pagination

How to return a page of results from SQL?

Many applications have grids that display data from a database table one page at a time. Many of them also let the user pick the number of records per page, sort by any column, and navigate back and forth through the results. What's a good algorithm to implement this pattern without bringing the entire table to the client and then filte...

Why is pagination so resource-expensive?

It's one of those things that seems to have an odd curve where the more I think about it, the more it makes sense. To a certain extent, of course. And then it doesn't make sense to me at all. Care to enlighten me? ...

Is there an ASP.NET pagination control (Not MVC)?

I've got a search results page that basically consists of a repeater with content in it. What I need is a way to paginate the results. Getting paginated results isn't the problem, what I'm after is a web control that will display a list of the available paged data, preferably by providing the number of results and a page size ...

How can you do paging with NHibernate?

For example, I want to populate a gridview control in an ASP.NET web page with only the data necessary for the # of rows displayed. How can NHibernate support this? ...

Keep pagination repeatable if change operations are performed

If one wants to paginate results from a data source that supports pagination we have to go to a process of: defining the page size - that is the number of results to show per page; fetch each page requested by the user using an offset = page number (0 based) * page size show the results of the fetched page. All this is works just fin...

What is the best way to paginate results in php

I need to display many pages of news in a site. Should i do the pagination in the db query using limit or do it in my php script after getting all the results? ...

What is the best way to paginate results in MS SQLServer

What is the best way (performance wise) to paginate results in SQL Server 2000, 2005, 2008 if you also want to get the total number of results (before paginating)? ...

Caching paginated results, purging on update - how to solve?

I've created a forum, and we're implementing an apc and memcache caching solution to save the database some work. I started implementing the cache layer with keys like "Categories::getAll", and if I had user-specific data, I'd append the keys with stuff like the user ID, so you'd get "User::getFavoriteThreads|1471". When a user added a...

Different odd/even pages in MS Access reports

For a report in MS Access (2007) I need to put data of some columns on all odd pages and other columns on all even pages. It is for printing out double sided card files onto sheets of paper. Does somebody have an idea how to do that? ...

JSP pagination without retrieving the whole result set?

I need to display the log entries from a database. Of course the log data is huge, so I have to show the results on several pages, and that **without** getting **all** the log data at once, but as the user navigates through the pages. I know about DisplayTag and TableTags, but it seems to me that they both fetch all the data before appl...

Why doesnt paginator remember my custom parameters when I go to page 2?

When using the paginator helper in cakephp views, it doesnt remember parts of the url that are custom for my useage. For example: http://example.org/users/index/moderators/page:2/sort:name/dir:asc here moderators is a parameter that helps me filter by that type. But pressing a paginator link will not include this link. ...

Smart pagination algorithm

I'm looking for an example algorithm of smart pagination. By smart, what I mean is that I only want to show, for example, 2 adjacent pages to the current page, so instead of ending up with a ridiculously long page list, I truncate it. Here's a quick example to make it clearer... this is what I have now: Pages: 1 2 3 4 [5] 6 7 8 9 10 11...

Is there a more efficient way of making pagination in Hibernate than executing select and count queries?

Usually pagination queries look like this. Is there a better way instead of making two almost equal methods, one of which executing "select *..." and the other one "count *..."? public List<Cat> findCats(String name, int offset, int limit) { Query q = session.createQuery("from Cat where name=:name"); q.setString("name", name);...

What is an efficient method of paging through very large result sets in SQL Server 2005?

EDIT: I'm still waiting for more answers. Thanks! In SQL 2000 days, I used to use temp table method where you create a temp table with new identity column and primary key then select where identity column between A and B. When SQL 2005 came along I found out about Row_Number() and I've been using it ever since... But now, I found a se...

PHP Dynamic Pagination Without SQL

I've got a script that dynamically calls and displays images from a directory, what would be the best way to paginate this? I'd like to be able to control the number of images that are displayed per page through a variable within the script. I'm thinking of using URL varriables (ie - http://domain.com/page.php?page=1) but am unsure how...

Is there a name for this type of page navigation?

Just out of curiosity, is there a name for the kind of navigation I've been working on? It looks like this: <<first <previous 1 2 3 4 5 [...] 20 next> last>> i.e. navigation where you've got x pages, but you don't want to show x links, you want to limit the amount of space taken up, so you show y links at a time, and indicate the exis...

Paginated query using sorting on different columns using ROW_NUMBER() OVER () in SQL Server 2005

Let's suppose I'm using the Northwind database and I would like to run a query via a stored procedure that contains, among other parameters, the following: @Offset to indicate where the pagination starts, @Limit to indicate the page size, @SortColumn to indicate the column used for sorting purposes, @SortDirection, to indicate ascendan...

Default to last page in a ListView

Using a standard ASP.NET ListView with a LinqDataSource and pagination enabled (with a DataPager), what would be the best way to default to displaying the last page of results? ...

How do you implement pagination in PHP?

How are paged results commonly implemented in PHP? I'd like to have a results page with 10 results. Paging forward in the navigation would give me the next and previous sets. Is there a way this is commonly done? Does anyone have simple advice on getting started? ...

Can You "Assign" the PageCount Property of an ASP.NET GridView?

I have a web application that is using a data store that has it's own built in paging. The PagedResult class tells me the number of total pages. What I would like to do it (after binding my ASP.NET GridView) do this: MyGridView.PageCount = thePageCount; And then have the GridView magically build the pagination links as it normally wou...