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 >
