> On Monday, June 25, 2007, 9:54:58 PM, Landry <[EMAIL PROTECTED]> wrote: > > > A problem remains, however : i don't know how to implement > > IDataProvider.iterator(int first, int count). > > Must be something like this in oracle : "select * from mytable where > rownum>>=first and rownum <count " > > Actually, in Oracle, it's significantly more complex than the above, > but let's not go there (unless you're actually doing that in Oracle?). > > > But how to do this in mysql ? (row_id could do the thing, but it is only > > available when your primary key is integer). > > I've not used MySQL for years, but I think it's > select * from mytable order by whatever limit first, count > where 'first' is from 0.
If you are using an ORM tool (JPA, Hibernate, JDO) the tool might do specific optimizations for you. But I think what most people (/ implementations) do is just scroll the result set cursor to the first record needed. Eelco 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
