ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From zkn <...@abv.bg>
Subject Re: read large result set in Ibatis3
Date Thu, 25 Feb 2010 10:53:45 GMT
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?

On 25.02.2010, at 12:49, Giovanni Cuccu wrote:

> hi,
>   because sometimes you can't. Consider for example a web service
> that must return 10k objects, paging the results is really cumbersome
> (even a web service that returns 10k can be cumbersome but you can't
> control everything).
> ciao,
>    Giovanni
> 
> 
> --------------------------------------------------------------------
> "You don't know the power of dark side" - Darth Vader
> 
> 
> 
> On Thu, Feb 25, 2010 at 11:42 AM, zkn <zkn@abv.bg> wrote:
>> Why not use limit and offset and work on a small subset instead of loading a large
result set? I believe this would be a better approach.
> .
> 
>> On 17.01.2010, at 01:54, Tomáš Procházka wrote:
> .
> 
>>> 
>>> Hi.
>>> 
>>> I need read large result set from DB (like 300 000 rows).
>>> 
>>> It's possible use this:
>>> 
>>> @Select({"SELECT * FROM send)
>>> List<Send> getAllItems();
>>> 
>>> .
>>> 
>>> 
>>> but instead of read all rows to List use server cursor and read only items which
will be accessed by Iterator.
>>> 
>>> I found some old article about this problem like:
>>> 
>>> http://stackoverflow.com/questions/1344362/java-retrieving-large-amounts-of-data-from-a-db-using-ibatis
>>> 
>>> But I don't know, that this is for iBatis 3.0.
>>> 
>>> Exist same ResultHandler implementation that can do this?
>>> 
>>> 
>>> --
>>> Tomáš Procházka
>>> 
>>> ---------------------------------------------------------------------
>>> 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
> .
> 
>> 
> 
> ---------------------------------------------------------------------
> 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


Mime
View raw message