search

emacarron / mybatis

Automatically exported from code.google.com/p/mybatis
0 stars 0 forks source link

fetchSize in iBatis Select #121

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
iBatis 3.0 . Actually I'm using iBatis with Spring, now I have a query which 
returns more records and so I want to limit the data (rows)
at one shot. Say, setting fetchSize='20', but seems like this is not
working and the query is taking a long time to get all the records at one shot.

Original issue reported on code.google.com by mdans...@gmail.com on 27 Sep 2010 at 5:38

GoogleCodeExporter commented 9 years ago 
Its a basic select Query.

Original comment by mdans...@gmail.com on 27 Sep 2010 at 5:39

GoogleCodeExporter commented 9 years ago 
MyBatis provides the RowBounds to fetch just the rows you want.

You can also write a custom SQL in your database SQL language. Maybe that could 
have a better performance.

Original comment by eduardo.macarron on 12 Nov 2010 at 1:52

GoogleCodeExporter commented 9 years ago

Original comment by eduardo.macarron on 30 Dec 2010 at 8:43