Windows Application Very Slow After Migrating Database from MSDE 2000 to SQL EXPRESS 2005

I am working on a smart client application, which uses SQL Express 2005 as datastore. Previously we were using MSDE 2000 for this purpose. Ever since the application migrated to SQL Express its very slow in performing CRUD operations.


I have done some research and found that AUTO_CLOSE option of database is turned ON by defualt, so if you turn it OFF then probably it will work faster.

Select "false" from Auto Close drop down in options panel and click OK. I am using SQL Management Studio.

Although this gives slight advantage of speed but not all system, some of users are still complaining for slow speed.