SQL CE 4.0 connection.Open takes a very long time on XP
-
11. března 2012 7:17
EMPTY database opens on XP ~20 seconds. on W7 - all ok.
i have recreated sdf on the XP machine. database is empty, and it didn't help. it still takes ~20 sec to open the database.
any suggestions
Všechny reakce
-
12. března 2012 15:03ModerátorAre you using encryption (= password) ?- is the user admin or std. user on the machine?
Please mark as answer, if this was it. Visit my SQL Server Compact blog
-
13. března 2012 2:44Moderátor Hi Ru. Tonik
Is your database encrypted? Please try to connect database without encryption. Do you have any other connection object open for the application? Do you use admin user account that installed SQL Server CE 4 on the XP machine?
What version of XP you are running? Please download and install XP SP3 because the older SP levels are not supported. You can download from here.
If you try to open a database from desktop on a device for the first time sqlce will recreate all the indexes and takes lot of time. But from second connection onwards you should not see any delay. For more information, please refer to this Blog.Regards, Amber zhang
- Označen jako odpověď amber zhangModerator 26. března 2012 3:16
-
13. března 2012 6:49
encryption is not used
XP Home edition SP3, user is admin
database was created on this machine. it's empty, no table.
i've tested on virtual pc with XP Prof, it works fine. but in production i'll have xp home (in many cases)upd. on the second test XP Prof, .Open takes ~18 seconds.
- Upravený ru.Tonik 13. března 2012 6:54
-
15. března 2012 19:17no more idias?
-
15. března 2012 20:44Moderátor
Sure:
- Test with Sysinternals Process Explorer to see what takes time
- Test 4.0 SP1
Please mark as answer, if this was it. Visit my SQL Server Compact blog
- Navržen jako odpověď amber zhangModerator 19. března 2012 7:44
- Označen jako odpověď amber zhangModerator 26. března 2012 3:16
-
20. března 2012 14:42
.png)
