Bhaarat,
If you're using mysql, you could do pagination using LIMIT statement,
which is pretty straight forward.
On Mssql - TOP (using cursors).
On Oracle - ROWNUM.
On Fri, May 15, 2009 at 7:14 PM, Bhaarat Sharma <bhaara...@gmail.com> wrote:
> that is a very interesting question. We were looking into doing pagination
> with iBatis as well but would not want a full scan on the DB but rather only
> get amount of rows specified by skipResults
>
> On Fri, May 15, 2009 at 12:10 PM, Alin Popa <alin.p...@gmail.com> wrote:
>>
>> Hi,
>>
>> I'm using iBatis with MySQL and also trying to do some pagination:
>>
>>
>> return getSqlMapClientTemplate().queryForList("getAll", skipResults,
>> maxRecords);
>>
>> and the "getAll" query:
>>
>> <select id="getAllVJobs" resultMap="simpleResult">
>> SELECT * FROM mytable
>> </select>
>>
>> Indeed, the pagination seems to work fine, BUT in mysql logs I see
>> executed the entire "SELECT * FROM mytable" which is a full table
>> scan.
>> Doesn't seems very right to me.
>>
>> Is there a catch behind this idea ?
>> Is fetching all records and after that iterate through them ? (I don't
>> think it's very nice this way).
>>
>> Any ideas ?
>>
>> Thanks.
>> Alin
>
>
--
Best Regards,
Alin
