-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 | I currently use MS Access as a single-user desktop database. The database is | getting quite large. The largest table has 300,000 rows.
Definately a case when an upgrade would help, but maybe it's not essential. We used to use a system here that maintained all its data in a shared access database on a winnt server box. It needed constant maintenance but i think we pushed to mdb up to about 700mb before it finally exploded ;-) | I am considering upgrading the database. How suitable is MySQL as a | single-user desktop database? How does it compare to Access when it is used | like this? Very suitable. Simmilar to Brian in his previous post I use MySQL as a desktop db under Linux. The MyODBC connector also provides a good way of accessing data through other applications. When the old system exploded, we initially moved all the data to a MySQL database and then used the old "front end" by linking the tables into a dummy access db through MyODBC! | Obviously MySQL would have advantages if I intended to use it as a server | database with concurrent users. But is it faster than Access in the | single-user environment, when dealing with large databases? Depends on your hardware, but in the MySQL world 300,000 records is considered "small". Either way, i think you'll get a lot more performance out of MySQL on a single user system than access. HTH danny - -- Danny Haworth =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Ge2 System Administrator Gas~Elec Safety Systems Tel : 01895 422 997 Email : [EMAIL PROTECTED] (mailto:[EMAIL PROTECTED]) -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.7 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQE9kWo3UKf+497XC3QRAhYyAJ4zv1bJiPXHA7G2uheSoJ61ANW7zQCgi+Fu /X8BthNnRHBASz/RgTHPg0Q= =SuSt -----END PGP SIGNATURE----- --------------------------------------------------------------------- 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