CODEWITHSUNDEEP
asp.netdatabase
nvcnvn
nvcnvn

Reputation: 5175

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 comparable to using SQLite with PHP?
Can you help me to choose?

Upvotes: 0

Views: 200

Answers (1)

Juan Jimenez
Juan Jimenez

Reputation: 5892

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)

Upvotes: 3

Related Questions