Hmm... Looks like your right. Sorry for the confusion. getAvailableRows() is called before prepare. On 17 Jan 2014 13:49, "George Christman" <gchrist...@cardaddy.com> wrote:
> I wouldn't say it's premature optimization when I'm essentially performing > two of the exact same free text queries, it's twice the work ;-) My company > is hosting our dev database remotely on awful hardware to help us to find > performance issues. They believe if we can make something fast on dev, it > will be lighting fast in production, so everything counts lol. > > Now if I understand GridDataSource correctly, you need to return the count > in availableRows() before the prepare() method can be called, is this > correct? If that is the case, I'm not sure how to go about combining this > into a single query do to the fact I would first need to get the count > before prepare is called to pass in the start / end index. > > hibernate-search, which is based on the lucene free text search engine will > return the total filtered result count while only returning the pagination > results. When using the Tap5 loop component, I typically just return an > object containing the total count and an array list of the results, but > seeing the prepare is called secondly, I'm not sure how to do this. I guess > worse case I can just do two queries. > > > > On Thu, Jan 16, 2014 at 5:51 PM, Lance Java <lance.j...@googlemail.com > >wrote: > > > 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 > > >> > > > > > > > > > > > > -- > George Christman > www.CarDaddy.com > P.O. Box 735 > Johnstown, New York >
