Is ACCDB faster than MDB using JDBC Bridge Connection for Java?

  • Thread starter Thread starter student2102
  • Start date Start date
S

student2102

I tried to retrieve all records in the from 3 database and I noticed some
delay. I did not do any testing but based on observation. I noticed using mdb
format is less than 0.5 seconds to access 3 tables and around 1 second when
retrieving records from accdb format.

Each database consist of a table. The size of the tables is 239, 14 and 1
records respectively. I use Windows XP Pro with SP3, Office 2007 and Netbeans
5.5.1.

I would like to know is ACCDB faster than MDB using JDBC Bridge Connection
for Java and should accdb faster than mdb in the retrieve of records?
 
Hi,

I have tested. The connection for Access 2007 is 0.172 sec and Access 2003
is 0.047.

I am using Windows XP, Office 2007 and Netbeans 5.5.1. I am using the laptop
to test the program. I think maybe that may affect a little.
 
Back
Top