On 6/10/07, Eelco Hillenius <[EMAIL PROTECTED]> wrote: > > if calling paging 1,2,3 n.... each time requires a call to > > iterator(first, count) and size(), which means a call to db, wouldn't this > > way, it ll give a bottleneck at the database layer? Imagine there are about > > concurrent 5000 users doing the paging....im sure the database will slowdown > > significantly? can it be any way where iterator() can return the size value > > as well, just to reduce to one query rather than 2 queries being made each > > time the paging is executed? > > No, this is not possible. Relational database don't work that way. > Read up on this first please, it's basic programming knowledge.
There is actually a way around, though with it's own potential ceveat. Read more on for example http://www.oracle.com/technology/sample_code/tech/java/codesnippet/jdbc/rs/CountResult.html Eelco ------------------------------------------------------------------------- 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
