Entity Framework 6 SQL Server Compact 4.0 Slow Startup

Problem

The development machine is 64-bit.  It takes ~20 seconds to open the SQL Server Compact database.

None of the online tips I’ve found fix it.

Partial Solution

The best I can do is to change the project property Build

I check Prefer 32-bit.

image

Now it takes 9 seconds to open, still too slow.

Reference:

http://erikej.blogspot.com/2013/08/faq-why-is-opening-my-sql-server.html

http://stackoverflow.com/questions/18113829/sql-server-compact-4-startup-loadnativebinaries-slow

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s