> -----Original Message----- > From: Allan, Mark [mailto:[EMAIL PROTECTED] > Sent: Wednesday, September 06, 2006 10:06 AM > To: sqlite-users@sqlite.org > Subject: [sqlite] SQLite vs MS Access > > Hi, > > After successfully using SQLite on an embedded device, we are > now thinking of using SQLite in a PC application. > > This would be used in place of an MS Access database on a > local/network disk. I believe that SQLite should be quicker > for both transactions and queries than Access. The one draw > back that comes to mind maybe portability (i.e. accessing > data outside of the application), although the data would be > portable across machines (PC, Mac, Unix, etc) should we ever > need it to be in the future. > > Is there any webpage, or does anyone have any information > comparing the benefits of the two. I can only find > comparisons between MySQL and PostgreSQL. This information > would aid us greatly in deciding whether to use SQLite or > stick with Access.
If you want some performance comparisons, I have them at: http://sqlite.phxsoftware.com/forums/thread/622.aspx Off the top of my head, here's what's wrong with Access: - It is not ACID compliant - It uses non-standard SQL syntax - Databases cannot be larger than 2gb - It is dead technology, having reach end-of-life at MS - Databases are massively bloated, further encroaching on the 2gb limit SQLite smokes Access in every category (speed of inserts/updates/selects/joins/etc) including db size. Robert ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
