If there's a concept in lucene that allows you to bring back the total rowcount and a page of data in a single query then the GridDataSource interface can support that.
On 16 January 2014 22:36, Lance Java <lance.j...@googlemail.com> wrote: > One query is for the rowcount, the other is for the results (for a single > page). > The only way to do it with one query is to add an extra column to the > result set for the row count. This value will be exactly the same for every > row in the result set. > > I personally don't see an issue with 2 queries... premature optimisation > perhaps ;) > > > On 16 January 2014 20:23, George Christman <gchrist...@cardaddy.com>wrote: > >> I found the following documentation >> >> http://wiki.apache.org/tapestry/Tapestry5HibernateGridDatasource2 >> >> However I'm still a little confused, I'm seeing two queries needed to get >> this to work, one containing the filtered results to get the availableRow >> count >> and the second one to get the prepare filtered result set containing >> startindex / endindex for get getRowValue(); >> >> With my hibernate search service, I'm able to get everything in a single >> query, is there anyway to do this in a single query? >> >> >> On Thu, Jan 16, 2014 at 2:48 PM, George Christman >> <gchrist...@cardaddy.com>wrote: >> >> > So I'm playing with the GridDateSource and was wondering how you are >> > suppose to get the filtered result count for availableRows()? With >> > hibernate search you get this count after the results have been >> filtered, >> > but the way the methods are called in GridDataSource, the availableRows >> > method is called before prepare. >> > >> > The next question is how do you get your filters back to GridDataSouce >> > prepare? I'm wondering if I'm going about this the right way. >> > >> > Example I'm working from >> > >> > >> http://jumpstart.doublenegative.com.au/jumpstart/examples/tables/griddatasources >> > >> > >> > On Thu, Jan 16, 2014 at 12:26 PM, George Christman < >> > gchrist...@cardaddy.com> wrote: >> > >> >> I guys, thanks for the help, I'm using hibernate-search with lucene. >> >> >> >> >> >> On Thu, Jan 16, 2014 at 12:10 PM, Ville Virtanen < >> >> ville.virta...@orientimport.fi> wrote: >> >> >> >>> Hi, >> >>> >> >>> here is one example: >> >>> >> >>> >> >>> >> http://jumpstart.doublenegative.com.au/jumpstart7/examples/tables/griddataso >> >>> urces >> >>> >> >>> Ville >> >>> >> >>> -----Alkuperäinen viesti----- >> >>> Lähettäjä: George Christman [mailto:gchrist...@cardaddy.com] >> >>> Lähetetty: 16. tammikuuta 2014 18:34 >> >>> Vastaanottaja: Tapestry users >> >>> Aihe: How to use grid with large data sets. >> >>> >> >>> Hello, I'm wondering how to use the grid component with large data >> sets. >> >>> Currently the grid is grabbing the entire data set rather than a sub >> set. >> >>> How do I pass back the current page and row count as well as the >> sorts? >> >>> Can >> >>> this be done with the grid component, or would I need to builds >> something >> >>> custom with a loop? >> >>> >> >>> -- >> >>> George Christman >> >>> www.CarDaddy.com >> >>> P.O. Box 735 >> >>> Johnstown, New York >> >>> >> >>> >> >>> --------------------------------------------------------------------- >> >>> To unsubscribe, e-mail: users-unsubscr...@tapestry.apache.org >> >>> For additional commands, e-mail: users-h...@tapestry.apache.org >> >>> >> >>> >> >> >> >> >> >> -- >> >> George Christman >> >> www.CarDaddy.com >> >> P.O. Box 735 >> >> Johnstown, New York >> >> >> >> >> > >> > >> > -- >> > George Christman >> > www.CarDaddy.com >> > P.O. Box 735 >> > Johnstown, New York >> > >> > >> >> >> -- >> George Christman >> www.CarDaddy.com >> P.O. Box 735 >> Johnstown, New York >> > >
