A REALLY good example of a paginated web service is amazon's merchant apis. I can't recall the exact name (AWS?), but I remember really liking how they implemented a usable web service on top of what is probably the largest product database on the web.
Clinton On 2010-02-25, zkn <z...@abv.bg> wrote: > My bad, sorry. > > But again the same thing works for a web service. You get a "page" from db > print it to the output stream then get the second page and continue > printing... Wouldn't that work? > For JasperReports I don't know because I've never used it and I don't know > how it works. Sorry again if my suggestions was off-topic. > > On 25.02.2010, at 13:00, Martin Ellis wrote: > >> 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 >> >> > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org > For additional commands, e-mail: user-java-h...@ibatis.apache.org > > -- Sent from my mobile device --------------------------------------------------------------------- To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org For additional commands, e-mail: user-java-h...@ibatis.apache.org