Re: MySQL vs Oracle vs Acess

2001-08-31 Thread Chris Johnson
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

Re: MySQL vs Oracle vs Acess

2001-08-31 Thread Adams, Bill TQO
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

RE: MySQL vs Oracle vs Acess

2001-08-31 Thread Simon Green
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