I've tried using SQL Server Compact Edition 4.0 for a certain Hunter HRMS application. The result was slow and I was getting "timed out waiting for a lock" exceptions. I did a lot to try to prevent any locks - close any open connections/DataReaders etc., even use NOLOCK hints, but still these timeouts would appear.
I then changed to SQL Express edition with minimal code changes to accommodate the change. All the problems disappeared - response time was excellent, with no timeouts.
Thought I should share this with the world.
Showing posts with label SQL Server Compact Edition vs. SQL Express Edition CE. Show all posts
Showing posts with label SQL Server Compact Edition vs. SQL Express Edition CE. Show all posts
Thursday, February 2, 2012
Subscribe to:
Posts (Atom)