I have a Struts-EJBs based J2EE application. In one of the scenarios, i have to displays 4000+ rows of data fetched through a stateless session bean on to a web page. Currently the system takes 60-70 seconds to do all this. Any suggestions to improve this time? btw the session bean returns the data in 30 secs and web-tier takes 1-2 seconds to generate the HTML from struts jsp.
Check the JDBC for Reading pattern.
you should use Entity EJBs or any other OR mapping only for the DB caching purpose (small amount of date, which are accessed more then once); otherwise use the JDBC
if you use the DAO pattern your business logic will not see a difference anyway