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 <z...@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-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
> .
>
>>
>
> ---------------------------------------------------------------------
> 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
