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

[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?

 

[Alex Dybenko]

Hi,
I don’t think there is much difference. accdb introduce new data type for
table fields, so if you are not using them - use MDB

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

 

[student2102]

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.