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
, September 02, 2005
1:08 PM
To: user-java@ibatis.apache.org
Subject: increase performance
Hello,
This is
regarding performance issue for a web log analyzer
application,which has following environments,
Apache 2.0.44 ,Tomcat 4.1.30, SQL Server 2000 with jdts JDBC driver
struts , ibatis
2.0.x
Hello,
This is regarding performance issue for a web log analyzer application,which has following environments, Apache 2.0.44 ,Tomcat 4.1.30, SQL Server 2000 with jdts JDBC driver struts , ibatis 2.0.x
Issue :i am
