ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Giovanni Cuccu <giovanni.cu...@gmail.com>
Subject Re: read large result set in Ibatis3
Date Thu, 25 Feb 2010 10:49:31 GMT
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


Mime
View raw message