I've used all three, Access, Oracle and MySQL. I have the least expertise
with Access.
My impressions are:
* Access is very limited in what it can do with respect to real database
manipulations, those contained in SQL. It does not handle large amounts of
data well. Access is really a very fan
Gene Gurevich wrote:
> them to Oracle. The developers are now considering
> switching from Access to MySQL and I'm trying to
> figure out what are the advantages of that move. I
Any DB is better than Access for a sizable table. Once access gets to about
100k records in a table it completely bom
OK
Well as you know MySQL has less bells and whistles vs oracle. This makes it
very fast.
The other thing with MySQL is that it is very reliable. The last thing is
that it can deal with very big databases.
So if you need a very fast DB but not all the stuff of oracle MySQL is you
database.
We use