Can you determine which part of the system is running slowly? One thing to try would be a simplified version of your application that doesn't access the database - if it is still slow then you know it's not related to the DB. You could also add logging messages at various points to measure how long different parts of the application take. That will tell you what operation is taking all the time. (I can't think of any particular reason why Win 2000 would be so much slower than Win XP.)
Also, make sure you're allocating a good amount of memory for the JVM on the slow machine, so it doesn't spend all its time in garbage collection. As for the Access database, I've used Access on a development machine with no problems. (I used the Access ODBC driver and Sun's JDBC-ODBC bridge.) Performance definitely wasn't as good as MySQL or SQL Server, but it was fine for development and testing. -- Len On 11/18/06, Gaurav Kushwaha <[EMAIL PROTECTED]> wrote:
I have a simple JSP-application that makes use of an ODBC database (access). When I run it using Tomcat on PC2 (XP) its performance is very good. However, running on PC1 (W2K Server) is orders of magnitudes slower! :-( I have already read most of the relevant manuals and tried various settings (server.xml, JAVA_OPTS, ...). No help. Has anybody observed similiar problems? Any help is appreciated... Gaurav Singh Kushwaha Ph: +91-9880101496 Bangalore, India. http://www.chakpak.com