Optmization tip when accessing two different databases
I just optimized a JSP page which displays live userlist and other relevant information by accessing two tables in two different databases. It was talking 168 seconds on my 600mhz machine. Now it takes 3 seconds! Trick was to HashMap info from one table with lesser info and rs.next() through the bigger tables and slower access database. Previously I was rs.next()'ing through the faster one and fetching details from the slower one.
<< Home