SQL Server or Access Database for ASP.NET web app?
Using Access Database (*.mdb or *.accdb) is very simple.
But I wonder about performance in comparison to using SQL Server in a production app with medium traffic websites! Is it compara开发者_运维技巧ble to using SQLite with PHP? Can you help me to choose?I have 4+ years of web experience and my advice is do NOT go with Access on web, and even on desktop for apps with a considerable number of users, SQL Server is far stronger, faster, more scalable and is easy to use too...
You will find that using a different DB is not that different in the end, it just depends on your data access provider (EntityFramework, ADO .NET, etc)
精彩评论