11
Good afternoon, I performed the migration of an application that ran in a windows ce to desktop, the Application uses Sql Server Compact 4.0. and runs very well in the development environment, I tested in other development machines and all run well, screens open normal and slow, but in other computers, slow occurs in most routines, I was able to notice that they’re usually in the routines where there’s interaction with the database. screens that open in 1 second in development machines, take 5 to 8 in other.
- On all machines were installed the Sqlce Server Compact 4.0 (Ssceruntime_x64-PTB)
- All the machines I ran the test have 64bit processors.
- Application has been compiled in Release.
- The bank is in the same folder of the application, the queries that are made in it in the machines that are slow, work, but require much more time than in the development machines
It is no problem of isolated slowness in a machine, or for lack of processing, because the application is quite simple, runs with few tables, tested on more than 1 server and showed the slowness.
I believe it is something that needs to be installed in the machines, but I did not identify what. I thank you in advance.
Possible cause/solution: http://stackoverflow.com/questions/20354917/sql-server-ce-extremely-slow-on-some-computers
– OnoSendai
I found this a few minutes ago and am checking. Thank you.
– André Luiz