On 25 February 2010 10:53, zkn <z...@abv.bg> wrote: > I use limit and offset exactly for this purpose. I think it's much better for > the application and the database server to get the total count with one query > and then just get the page you actually need and want to show to the user. > You don't really need to show 10K rows on a single page to user, do you?
Giovanni is talking about web services, not web pages. Also, the JasperReports example mentioned earlier in the thread could be part of a batch process for all we know. The point is: not every application is a web application. Martin --------------------------------------------------------------------- To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org For additional commands, e-mail: user-java-h...@ibatis.apache.org
