I've read the link you provide. This lets you retrieve from N to M records instead of every record that matches the criteria you're asking for.
But in the case of pagination, once the dataScroller has arrived to the last record in the subset you have recovered from DB, how can you tell the component to continue retrieving more records (if they are available)? And also, if you only get a subset, how can the dataScroller now how many records are in total to show you the pagination? I've been thinking in this lazy pagination solution, and it would be perfect whether Hibernate could fecth in blocks. I mean, when you assign your Hibernate collection to the dataScroller, instead of materializing all the records, just materialize, for example, 100 (out of 10000). And then, when the next block is needed, lazy load it, and so on... What do you think? On 4/23/05, Joshua Davis <[EMAIL PROTECTED]> wrote: > > The online documentation has an example here: > http://www.hibernate.org/hib_docs/v3/reference/en/html/objectstate.html#obje > ctstate-querying-executing-pagination > > The Query interface has two methods: setFirstResult(int) and > setMaxResults(int). > As usual, Hibernate takes care of making sure that this will work with the > database you are using via it's 'Dialect' support. If you want to see how > Hibernate does this for a specific database say, because you can't use > Hibernate for your project, then download the source code and have a look at > the Dialect classes. > > -----Original Message----- > From: Enrique Medina [mailto:[EMAIL PROTECTED] > Sent: Saturday, April 23, 2005 5:45 AM > To: MyFaces Discussion > Subject: Re: paginator, datatable and performance > > Hi Joshua, > > This is an insteresting issue. Could you give some extended information > about Hibernat'es feature of row limit? > > On 4/22/05, Joshua Davis <[EMAIL PROTECTED]> wrote: > > Easy... Just use Hibernate's row limit features in conjuction with the > > paginator. > > > > [EMAIL PROTECTED] > > > > --- Slawek <[EMAIL PROTECTED]> wrote: > > > hi > > > > > > suppose we have table in database containing many records (more than > > > 10 > > > 000) and we want to display them in table... > > > obiously we use paginator:) > > > > > > but we dont want to get all record form databese cause we need to > > > wrap them "in fly" (or sth) - hevermind, lets just say that we can > > > get at once from datatabse only 100 records (cause our table is set > > > to show ony 100 rows). > > > geting all 10 000 records and doing sht "in fly" > > > would kill performance:/ > > > > > > but to use paginator we must get all rows (paginator "take care" > > > about counting and so on) > > > > > > is there any poibility to use standard paginator and not fetching > > > all rows at once from database? > > > > > > S�awek > > > > > > >
