ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bhaarat Sharma <bhaara...@gmail.com>
Subject Re: iBatis - MySQL pagination
Date Fri, 15 May 2009 16:14:51 GMT
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.popa@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
>

Mime
View raw message