aspose file tools*
The moose likes JDBC and the fly likes MSAccess database in my application Regarding Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "MSAccess database in my application Regarding" Watch "MSAccess database in my application Regarding" New topic
Author

MSAccess database in my application Regarding

sriram krishna
Greenhorn

Joined: Nov 21, 2011
Posts: 6
Hi,

My application is a single user, stand alone application. I just want to use access database for this. Of course, there are many java related databases for this purpose which are better than access. I have searched for the details of access database and jdbc-odbc bridge driver in sun's websites, google and in this forum also. So many people are suggesting that access is the last case to use. Luckily mine is single user application, with single connection to the database, and perfectly matches to my requirement.

At last i have a question in my mind about the bridge driver. Is the bridge driver will be a bottle neck when the table rows in access database goes in the order of thousands?? please add any points if i have missed regarding the access database to your answers.

Thank you.
Keith Rainey
Ranch Hand

Joined: Jan 19, 2011
Posts: 66

I you are not finding any documented test results on using MSAccess databases, you can perform your own tests. You are probably the best judge of whether the performance is acceptable for you.

Build a test app to insert/modify/search/delete records and take time measurements of each operation with a wide variation in the number of records affected.


Keith Rainey
OCPJP6
Paul Clapham
Bartender

Joined: Oct 14, 2005
Posts: 18909
    
    8

Of course it's a bottleneck -- in the sense that the data is constrained to go through it and you have to wait while that happens. But that is true of all databases, so really, asking whether it's a bottleneck is rather useless.

However perhaps the question you really wanted to ask is "Is Access combined with the JDBC-ODBC bridge driver going to be fast enough to satisfy me?" In which case Keith Rainey has already provided a full answer to that question, I believe.
sriram krishna
Greenhorn

Joined: Nov 21, 2011
Posts: 6
Thank you.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: MSAccess database in my application Regarding