Java Forum

Ask Question   UnAnswered
Home » Forum » Java       RSS Feeds

MySQL vs. Access

  Asked By: Madeline    Date: May 27    Category: Java    Views: 747

Just curious on the opinions out there of using MySQL vs. Access for
a J2EE web application to connect to. Is one easier to manage than
the other? I have heard that there are limitations as to the number
of rows that can be stored within Access. Anyone know if this is
true and what the limit is?



4 Answers Found

Answer #1    Answered By: Blas Fischer     Answered On: May 27

MySql is a suitable choice for a J2EE application. I have not used it
personally so
I don't want to endorse it but I know that a fair amount of successful J2EE
use MySql.

Generally speaking access  is unsuitable for any large appliation. Its primary
intention is for a single user database (your cookbook for instance). Access
work fine during development and perform horribly in production once multiple
are hitting it.

Check the user manual on the number of rows. I'm pretty sure the number of rows
limit is very high. However this is not entirely myth. Although you can save
number of rows  in an access database performance degrades substantially as the
increases. In particular performance with the Microsoft DAO driver is extremely
problematic (the exact number of rows is a function of available memory) and
other drivers available are built on top of this driver. Thus you might be able
import 10 million rows with access but then not use them efficiently in your
application with jdbc.

Answer #2    Answered By: Tara Ryan     Answered On: May 27

from what I am studying, MySQL is better than Access in large applications.
MySql is much better - it gives better performance.

Answer #3    Answered By: Sam Anderson     Answered On: May 27

I know next to nothing about Access,
but I love MySQL. It's fast and easy.
There was a benchmark run a while ago
(wish I could remember the reference)
wherein MySQL beat everything else
hands down except Microsoft SQL Server
IF SQL Server was running on a finely
tuned MS-only platform. MySQL doesn't
have stored  procedures yet (supposed
to come out in version 5) but I don't
know if Access has those either or if
you need them. My experience is that
you usually don't unless you're running
a high-demand system. Besides, MySQL
is default on almost every commercial
Web account, so it makes sense to
develop Web applications using it.

Answer #4    Answered By: Mehreen Malik     Answered On: May 27

I found that reference, but I guess
remembered some of it wrong. Oracle 9
and MySQL were neck-and-neck. I think
the SQL Server conditions I mentioned
were true, but that might have come
from another test.


But this benchmark was for Java
environments, so it's probably what
you want to read, anyway.

Didn't find what you were looking for? Find more on MySQL vs. Access Or get search suggestion and latest updates.