iBatis will not return the results faster than DB.
Do a showplan on your querry, or have a senior developer that knows SQL look at the querry.
It looks like somone went out of the way to force a tablescan and sort of 5 million records.
.V
---------------------------------------------------------------------------------------------------------------------
Broadband interface (RIA) + mail box saftey = Roomity.com
*Your* clubs, no sign up to read, ad supported; try broadband internet. ~~1125700443374~~
---------------------------------------------------------------------------------------------------------------------
