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:42:48 GMT
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


Mime
View raw message