Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Sun JDBC-ODBC driver to Microsoft Access DB slow in certain circumstances

Posted on 2004-04-16
11
Medium Priority
?
1,059 Views
Last Modified: 2007-12-19
Hi,

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).

My question:
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.

Thanks!

Pam.
0
Comment
Question by:icekalt
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
  • 2
  • +2
11 Comments
 
LVL 9

Expert Comment

by:mmuruganandam
ID: 10840470
The ODBC itself is too slow just because of the reason that it is not multi-threaded.  So when there is many calls at a time, each call will be processed one by one.

I don't think you have drivers for that.  Still search out you may find one.
0
 
LVL 35

Expert Comment

by:TimYates
ID: 10840695
I'm not sure if the JTDS driver works with Access or not...

It works with SQL Server...and MAYBE Access...

http://jtds.sourceforge.net/
0
 
LVL 35

Expert Comment

by:TimYates
ID: 10840697
Hmmm...reading the FAQ, it doesn't look like it does....sorry...
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 9

Expert Comment

by:mmuruganandam
ID: 10840709
It supports only for

JDBC 2.1 driver for the Microsoft SQL Server series (6.5, 7.x and 2000) and Sybase 10.
0
 
LVL 30

Expert Comment

by:Mayank S
ID: 10840843
You might try to use Connection pooling, if that's possible. I'm not sure if there is a driver for Access that allows pooling, but you can spend some time reading: http://webdevelopersjournal.com/columns/connection_pool.html
0
 
LVL 86

Expert Comment

by:CEHJ
ID: 10842136
Proabably easier to get a proper, free database
0
 
LVL 30

Expert Comment

by:Mayank S
ID: 10842154
Pay attention to the important word: >> *proper*

;-)
0
 
LVL 35

Accepted Solution

by:
TimYates earned 1000 total points
ID: 10843018
0
 
LVL 86

Expert Comment

by:CEHJ
ID: 10843068
Not forgetting HSQL, depending on the scale of the application being quite small

http://hsqldb.sourceforge.net/
0
 
LVL 14

Expert Comment

by:Tommy Braas
ID: 10843761
I would recommend in the short term to basically create the connections you need, and keep them alive. Creating new connections to a database is quite expensive (read takes time). In one of my applications I use a connection object that I keep around for each DAO, although that approach doesn't scale well to many DAOs, it works for my case with 8 DAOs. It might work in your case as well.
0

Featured Post

Build and deliver software with DevOps

A digital transformation requires faster time to market, shorter software development lifecycles, and the ability to adapt rapidly to changing customer demands. DevOps provides the solution.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

For beginner Java programmers or at least those new to the Eclipse IDE, the following tutorial will show some (four) ways in which you can import your Java projects to your Eclipse workbench. Introduction While learning Java can be done with…
Introduction This article is the second of three articles that explain why and how the Experts Exchange QA Team does test automation for our web site. This article covers the basic installation and configuration of the test automation tools used by…
Viewers learn about the scanner class in this video and are introduced to receiving user input for their programs. Additionally, objects, conditional statements, and loops are used to help reinforce the concepts. Introduce Scanner class: Importing…
Viewers will learn about basic arrays, how to declare them, and how to use them. Introduction and definition: Declare an array and cover the syntax of declaring them: Initialize every index in the created array: Example/Features of a basic arr…
Suggested Courses

670 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question