开发者

SQL Server or Access Database for ASP.NET web app?

开发者 https://www.devze.com 2023-04-05 19:05 出处:网络
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!

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)

0

精彩评论

暂无评论...
验证码 换一张
取 消