Sun JDBC-ODBC driver to Microsoft Access DB slow in certain circumstances
Posted on 2004-04-16
My Java 1.3 application connects to a local Microsoft Access DB (200MB+) using Sun's JDBC-ODBC driver. When running queries, it's performance is acceptable (a few seconds) when the application is running on Microsoft 98 or 2000, and completely unacceptable on Microsoft XP Pro or Home (a few minutes). I changed to another driver and it's performance is now the same for 98, 2000 and XP (a few seconds).
1. Why the discrepancy? Why would the driver work well on some operating systems and not on another? It's exactly the same JRE, same application, same data. Is there anything (for example, a patch) environmental that I can change on the XP machines that will fix the problem?
2. If there's nothing that can be done to enhance the Sun driver's performance on XP, are there any good free drivers? The application is installed all over the country, and so replacing the driver will not make business sense.