Hi All, I am working on webapplication which is developed using Servlets,jsp and some simple java classes. This application needs to interact with multiple databases ( few databases from another server machine), and all JDBC stuff done in one java class and that class is using accessed in servlets. Though its working well but it takes lot of time to run from page to page.
please give feasable solution to improve the performance. (Alternate way to access the database)
Um, write better SQL? If it is taking a long time look at where the bottle necks are. Look at whta you are doing to help the user and see if you really need to display all of that data or if there is another way to do it.