Hi Prashant. There is no problem to execute that queries in one
session. And depending on the tx isolation or the locking policy you
are using you may see other commits or not.
The RowBounds parameter does something similar, try with it to see how
well it behaves. The memory consumption and performance depends also
on your driver/database.
El día 29 de marzo de 2012 23:55, Prashant Neginahal
<
[hidden email]> escribió:
> In that approach, all pagination queries will not be executed in one
> session. We may loose the data if it is modified by other session in
> between.
>
> I found this link has answer.
>
http://stackoverflow.com/questions/6546136/handling-very-large-amount-of-data-in-mybatis>
> Is it correct?
>
> Thanks,
> Prashant
>
> On Mar 29, 5:04 pm, Eduardo Macarron <
[hidden email]>
> wrote:
>> not that I am aware of...
>>
>> I suppose you should paginate it using your database specific syntax for it.
>>
>> El día 29 de marzo de 2012 22:44, Prashant Neginahal
>> <
[hidden email]> escribió:
>>
>>
>>
>>
>>
>>
>>
>> > Hi,
>>
>> > My select query reads large amount of data. I do not want to use one
>> > SELECT query. Is there any way to reacd data in chunks with same
>> > session?
>>
>> > Thanks,
>> > Prashant
Locked
