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

Question

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?

just forget the word "Access" anytime you talk about "Production". SQL Server as backend database for web sites is ok, used in StackOverflow as well and as you see it out/over performs :) — Davide Piras
– Davide Piras, Commented Sep 16, 2011 at 3:18

Stefan Steiger · Accepted Answer · 2012-11-02 12:48:51Z

3

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)

edited Nov 2, 2012 at 12:48

Stefan Steiger

83k70 gold badges405 silver badges461 bronze badges

answered Sep 16, 2011 at 4:03

Juan Jimenez

5,8926 gold badges30 silver badges37 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

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

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related