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-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
