> 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. Also, please keep all your replies to one thread (don't change the topic) unless you intend to talk about a new topic. 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
