hie Gwyn, May be this will help - read all the threads http://www.nabble.com/RE%3A--Contract-for-%22Iterator-IDataProvider.iterator%28int-first%2C-int-count%29%22-----tf1395451.html#a11057660
Gwyn wrote: > > Hi, > > Anyone got any suggestions as to the best way to provide a paging > data view without requiring using size() to actually count the records > in DB? > > I've got a site that has a production DB such that > "select COUNT(*) from mytable" > takes a non-trivial amount of time/cpu to return, whereas to get > the actual data for the page is effectively immediate! > > I'm curently using a DefaultDataTable and the quick hack is to just > hard-code DataProvider.size() to just return a fixed number, but while > that's probably OK, it's sub-optimal (it is just a util for my own > use though, really). Having said that, I'd be interested in > alternative suggestions. > > It's the Production DB only that shows this behaviour (which is > probably related to them not purging the the old data for 4 years or > so, so I'm limited as to what might be possible with the DB itself). > > -- > Best regards, > Gwyn mailto:[EMAIL PROTECTED] > > > ------------------------------------------------------------------------- > This SF.net email is sponsored by DB2 Express > Download DB2 Express C - the FREE version of DB2 express and take > control of your XML. No limits. Just data. Click to get it now. > http://sourceforge.net/powerbar/db2/ > _______________________________________________ > Wicket-user mailing list > Wicket-user@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/wicket-user > > -- View this message in context: http://www.nabble.com/Paging-data-without-using-DataProvider.size%28%29---tf3999431.html#a11374231 Sent from the Wicket - User mailing list archive at Nabble.com. ------------------------------------------------------------------------- This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ Wicket-user mailing list Wicket-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wicket-user