How much data are you getting back with your query? 10 rows? 100 rows?
1000 rows? 1 rows?
If you are getting back more than you *need* for the report, you
should look at doing all the data processing with a stored procedure
instead of in Java code. This will improve performance in several ways
Jean-Francois,
Thanks for the reply and agreed your comments.
We have also identified the SQL query optimization makes the big difference in the performance,so we modifed the quries as much as possible.
Moreover,
1. we have not implemented the cache model till now,so we are planning to include
Hi,
From what I can see, this is not in iBATIS
that you should look for better performance but in your SQL select statements.
It is always a bad idea, in a where
clause, to use a function on an indexed column like in:
SUBSTRING(NewLog_T.date,1,4) = #syukeiYear_#
AND
This way,
