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
