CODEWITHSUNDEEP
sql-serversql-server-2005performancesql-server-2008sql-server-express
Zoltan Veres
Zoltan Veres

Reputation: 355

Measuring performance hits between SQL Server database and SQL Express User Instances (.mdf type database files)

Has somebody measured performance differences between "real" SQL Server database and a SQL Server Express user instances (attached .mdf database file)?

What was the conclusion?

Was the .mdf database file fast enough for your application?

Upvotes: 0

Views: 817

Answers (1)

marc_s
marc_s

Reputation: 754258

.MDF type IS SQL Server...........

OK, so you want to know about how attaching a .MDF file as a user instance behaves in SQL Server Express. I've never really used that feature myself, but from all I understand, the only difference is that SQL Server Express must attach the .MDF file before first using it during a session.

So you will experience a certain delay when the first request comes in - how much that is really hard to quantify and depends on your hardware, mostly (disk speed, available RAM). It should definitely not be more than a few seconds.

Once attached, as far as I understand it, there's no difference between a SQL Server Express user instance database and a "proper" real-life SQL Server Express database. So I don't think this is a major issue in terms of performance.

Upvotes: 3

Related Questions