Slow performance of JDBC - ODBC MS ACCESS

I experience a very slow performance for jdbc-odbc using ms access as the database. This program works fine with other computer (in term of performance). However, the harddrive is cranking big time with this computer (this is the fastest one among the computers I tested, and also has many gigabytes left to be used). The database is very small. Other computer use exactly the same java version and msaccess driver version. If anyone found the same problem, or have any suggestion please help. Thank you.

[518 byte] By [vy_ho] at [2007-9-26 3:49:50]

«« Problem with Blob
»» ServletContext

# 1

You run the program on one computer and it works fine.

You run it on another computer and it is slow?

You don't have a java problem. You have an environment problem. The most likely cause from the brief description that you gave is that one machine has little physical memory. Consequently it is paging the hard drive, which will slow things down.

jschell at 2007-6-29 12:34:49 >

top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...

# 2

I am having the same problem with one machine as well. Running MS Access 2000 (unfortunately), and all machines run well with one exception. DB reads take about 10 seconds each. If a solution has been found, please report.--Dave

sassy_dave at 2007-6-29 12:34:49 >

Java Database Connectivity (JDBC)

Java programming resources: FAQs, tutorials, compiler and browser download sites, documentation, books lists, IDEs, etc.

Slow performance of JDBC - ODBC MS ACCESS

Database Connectivity New Topic

Database Connectivity Hot Topic

Database Connectivity

All Classified