Hi All, Which database you all prefer for making your application? MS Access, My SQL or Oracle? Please give me reason also - why you chosen the particular? Your help will be highly appreciated.. Regards,
Yes it depends on what you want to achieve... Personnaly I'd use Access for small VB applications that someone would ask me to code for a small company, then MySQL for anything related to the internet, and Oracle well the rest, mostly applications used in large companies...
Depends what you're planning on making e.g for php scripts on a website, MySQL is the best. For ASP.net driven apps MSSQL or access is the best.
If you have the money, MSsql, if you have even more money, Oracle. If you have to ask how much, best to develop the project on access or MySQL.
It merely depends on you, your expertise level and the level of business requirements. to put it simple, here we go Access: For Kids MySQL: Professionals Oracle: Gurus And above that its totally depending upon your project requirements. Hopefully you wont like killing a bee with a cannon
Difference between Oracle SQL and the SQL generated by Microsoft Access when using the QBE interface. Although most of the time one need not be exposed to SQL in Access it can be useful to understand the structure of SQL and when it generates clauses and extra brackets unexpectedly. It is also useful to know how Access SQL differs from the more standard SQL of Oracle. Microsoft Access tables are normally built using Table button. SQL commands are used to create, query and maintain a database.
I found MySQL to be the best for any web applications. I've only ever used Oracle in school but you can very much see how it's geared for large scale enterprise applications. Access is only really useful for tiny applications that will never have large amounts of transactions and records.
Access: People who think a database should look like Excel Oracle: Overqualified programmers getting paid far too much money MySQL: Anyone who wants a real database that works (until one of the above gets control of your IT)
MySQL. Optimize your could for the least amount of calls. If you suck at code or your site starts getting a ton of traffic look into get memcached on your server. Thank me later.
DB need decide which is best. Mostly my-sql fulfill all situations.. Access n oracle are mostly same..
Access is only really good for up to 30 concurrent connections (according to MS). I can verify this as all my software has an optional MS Access backend and we have used 30 concurrent connection systems many times with no problems whatsoever. MySQL is better for more concurrent connections and provides much better possibilities for future growth. They are both databases, by the way. Regardless of what the MS bashers think.
With this hxxp://sourceforge.net/projects/benchmark/"benchmarak you can do some tests and see results of performance of most famous database : Oracle Berkeley DB, MySQL (server), STSdb, MS SQL Server CE, Access, Perst, SQLite, Db4objects, Firebird, HamsterDB, H2....
Access is for small projects. It is not meant to use as a backend for you application. One drawback that I can think of is let say you want to change field names in your database, and you need to put it up to the server. It would get you a error saying file is being used by another user, so you would have to restart your server in order to upload you whole database. I would say Mysql is the best for it is free and fast.