SQL Server CE4.0 runs very slow in windows XP

Question

Hi,

We currently run into an issue where access to our CE4.0 database is very slow under windows XP. Any query takes about 10 seconds to run. It runs nearly instantly on our Win 7 development machines. According to our profiler, the "OpenStore" method takes all the time.

We have .net 4.0 installed. The database file is writable and we know that the file is written to because the modified time changes.

Any clue on where to look for a solution?

Is there any parameters that can be put in app.config that would enable logging/tracing of a CE 4.0 application?

 

Answer 1

Is your database encrypted? Test without encryption. Are you running XP SP3 (older SP levels are not supported).

Do you open and close connections, or do you keep a connection object open for the lifetime of the app?

---

Please mark as answer, if this was it. Visit my SQL Server Compact blog

Answer 2

Update:

We are on SP3. We use Entity Framework and linq to entity, which seems to re-open the connection at every time we access data.

With encryption, we have the following behavior:

- On the user account (admin) that installed SQL Server CE 4 on the XP machine, it runs fast.

- On a user account (another admin) that did not install SQL Server CE 4 on the XP machine it runs very slow. If that user re-creates a new database on the XP machine, it still runs slow.

Without encryption:

It runs fast, even for a user that did not proceed with installation.

Is there anything that gets a user specific configuration when installing SQL Server CE 4.0?

 

Answer 3

whether it slows down when you insert?

Answer 4

Hi,

Did you ever find the solution to your problem?

We are currently experiencing the same thing: it runs just fine on a Windows 7 box, but running under Windows XP it runs very slowly. We're using LINQ to entities also, and we're using encryption...

TIA,

/Kenneth

Answer 5

See this thread, kenneth: http://social.msdn.microsoft.com/Forums/en-US/sqlce/thread/1b21bb10-1fa3-4954-87d2-f3fa61e8256a

---

Please mark as answer, if this was it. Visit my SQL Server Compact blog