ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Larry Meadors <larry.mead...@gmail.com>
Subject Re: Excessive memory usage (feature or bug?)
Date Tue, 20 Jan 2009 18:34:47 GMT
Look into using the LIMIT keyword in your select.

Something like this:

select *
from city
where syncDate < ?  and syncDate > ?
limit $skip$, $max$

You'll need to add those values to the parameter object.

Larry


On Tue, Jan 20, 2009 at 11:22 AM, Jeff P <killingdjef@hotmail.com> wrote:
> I'm using MySQL with MyConnectorJ5.1.7

Mime
View raw message