ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Clinton Begin <clinton.be...@gmail.com>
Subject Re: read large result set in Ibatis3
Date Thu, 25 Feb 2010 13:50:04 GMT
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 <zkn@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 <zkn@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-unsubscribe@ibatis.apache.org
>> For additional commands, e-mail: user-java-help@ibatis.apache.org
>>
>>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
> For additional commands, e-mail: user-java-help@ibatis.apache.org
>
>

-- 
Sent from my mobile device

---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
For additional commands, e-mail: user-java-help@ibatis.apache.org


Mime
View raw message