Results 1 to 5 of 5

Thread: Paging without total count, Google style

  1. #1

    Default Paging without total count, Google style

    Hi,

    We are using a very complicated database structure with frameworks.
    For some reasons we don't want to hit more then one question at a time. Result + size.
    Complicated, dynamic questions with hibernate, a bottleneck in db connections and very large result sizes.
    So we want to create a paging solution similar to the one Google is using. Basically with no total count and only showing the result with its closest neighbors to get the paging to work.

    For example we have a result set of 5 million rows and a lot of nested data and we would like to show only the current page and +- 5 pages to navigate to or something like that.

    So the question is how is the best way to do this?
    Have anyone done something like it or do we have to build our own component.

    All suggestions are appreciated!

    Thx
    /CD

  2. #2
    Sencha User
    Join Date
    Mar 2007
    Location
    The Netherlands
    Posts
    24,245

    Default

    The easiest method probably is:
    1. Have your server always return a totalCount that is larger than the last record that it returns (unless it actually is the last record).
    2. Hide the 'Last Page' button.
    3. Change the paging toolbar displayMsg, so it doesn't show the number of pages.

  3. #3
    Ext User
    Join Date
    Jul 2008
    Location
    Swindon, UK
    Posts
    73

    Default

    I'd suggest using hibernate search. We've switched to this and our searches across millions of rows/tables are in the region of 100ms.

    Hibernate will auto index your entities, even cascading down to collections.Hibernate then returns objects from the index and/or the database as needed. Just add @Indexed to youir class and @Field to those fields you want to index and hibernate does the rest. It really is transparent.

    We then use the Paging Grid or the Live Grid across the set. This solution gives blindingly fast searches with correct display on paging ("Displaying 300-350 of 1,234,987 rows").

    Give it a go.

  4. #4

    Default Thx

    Thank you,

    That worked perfectly.
    Overriding the onRender method and hiding some elements did it.

    We will also look into the Hibernate Searrch in the future.

    /Skinny

  5. #5
    Sencha User
    Join Date
    Apr 2013
    Posts
    45

    Default

    Quote Originally Posted by Skinny View Post
    Thank you,

    That worked perfectly.
    Overriding the onRender method and hiding some elements did it.

    We will also look into the Hibernate Searrch in the future.

    /Skinny
    How can you do that? i got the same problem.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •