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 bombs (queries take forever).
If you put an Access db on the network, when you query a table in said db,
Access copies the table to a local drive the first time. If the table is large
(in file size) and your connection is slow, e.g. a T1, then the first time you
run a query on a table it can take a loooong time.
If users do create tables in Access, be sure that they do not give
tables/columns stupid names like "Run #", or "A Name With Spaces", etc.. Even
MS SQL Server will not handle such atrocities even with the 'Upsize' Add-In
(sounds like a value meal) should someone want to move the table to a
different database at a later time.
As for oracle versus MySQL: I have very little experience with Oracle but the
way it handles dates and strings makes my head hurt.
--Bill
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
