Google I/O 2010 – GWT’s UI overhaul javadocs package com.google.gwt.cell.client in 2.1 Eclipse update site for milestone 2 While the code is in bikeshed, add this line to your gwt.xml file: <inherits name=”com.google.gwt.requestfactory.RequestFactory”/> The following examples follow: CellList of TextCells with PageSizePager CellList of TextCells with a SimplePager CellList of TextCells with a SimplePager and … Read more
I encountered some performance issues using the COUNT() OVER() method. (I’m not sure if it was the server as it took 40 seconds to return 10 records and then later didn’t have any issues.) This technique worked under all conditions without having to use COUNT() OVER() and accomplishes the same thing: DECLARE @PageSize INT = … Read more
Here’s my solution – use “Logarithmic Page Navigation”: This can be achieved by having page numbers distributed logarithmically, according to distance from either the endpoints or the current page. Here’s an example of what I mean: 1 2 3 4 5 6 . 10 . 20 . 30 . 40 . 50 .. 100 .. … Read more
You can use the Row_Number() function. Its used as follows: SELECT Row_Number() OVER(ORDER BY UserName) As RowID, UserFirstName, UserLastName FROM Users From which it will yield a result set with a RowID field which you can use to page between. SELECT * FROM ( SELECT Row_Number() OVER(ORDER BY UserName) As RowID, UserFirstName, UserLastName FROM Users … Read more
You can achieve the desired result by requesting a list of distinct ids instead of a list of distinct hydrated objects. Simply add this to your criteria: criteria.setProjection(Projections.distinct(Projections.property(“id”))); Now you’ll get the correct number of results according to your row-based limiting. The reason this works is because the projection will perform the distinctness check as … Read more
Save your sorting order in a ViewState. private const string ASCENDING = ” ASC”; private const string DESCENDING = ” DESC”; public SortDirection GridViewSortDirection { get { if (ViewState[“sortDirection”] == null) ViewState[“sortDirection”] = SortDirection.Ascending; return (SortDirection) ViewState[“sortDirection”]; } set { ViewState[“sortDirection”] = value; } } protected void GridView_Sorting(object sender, GridViewSortEventArgs e) { string sortExpression = … Read more
First of all I want repeat that I don’t recommend you to use local sorting and the server side paging. I find that the user can wrong interpret the result of sorting. Nevertheless, if your customer agree with restriction which have the combination of local sorting and the server side paging and if you really … Read more
Using skip+limit is not a good way to do paging when performance is an issue, or with large collections; it will get slower and slower as you increase the page number. Using skip requires the server to walk though all the documents (or index values) from 0 to the offset (skip) value. It is much … Read more
You’re looking for the Skip and Take extension methods. Skip moves past the first N elements in the result, returning the remainder; Take returns the first N elements in the result, dropping any remaining elements. See MSDN for more information on how to use these methods: http://msdn.microsoft.com/en-us/library/bb386988.aspx Assuming you are already taking into account that … Read more