sql server - SqlCE DB occasionally freezes on one handheld, not another -

I have two types of custom handhelds that are similar, but slightly different, running each WinForm application and a WinCE database Type 1: Vinay 4.2, 400 MHz, 93244 KB Type 2: Win CE 5.0, 520 MHz, 84208 KB

Type 1 will happily move forward through a large batch DB operation, Crawling will start continuously (for multiple cycles) around 200 cycle mark by type 2 at this point at several points Will start walking and will crawl again.

Many DB sessions in the AP (inserts, updates and selects, no one deleted).

To make my situation easier, I has created a small test app that essentially does this:

  command_. Common text = "Choose DVR from VR where weed = 2211250"; Command_u.CommandText = "Setup Update PVR LocationID = 81 where position = 'OK' and '= 27861;'; while (going) {command_s.ExecuteScalar (); command_u.ExecuteNonQuery ();}  < / Pre> 
 and shut it down with two units. Needed, the slower (400 MHz) unit is faster than the (520 MHz) unit (it's about 5000 cycles now) and I'm 520 
 
 
 
 
 

< P> You have given us your The test does not tell much about the environment, assuming that you are using the same version of SQL CE on both, it is probably that the driver (file system or bus) on either slow system is either slow or real media On which you are storing.

For example, one of them was writing RAM and to flash another, then clearly the RAM device is going to perform very fast. Maybe that is using a NAND and second Note slowness slow using Flash and writing NAND is affecting you. Or maybe you are using USB and the speed of the USB bus in one system is very high.

Given this inequality and without knowing lot about your targeted hardware, why is it difficult to tell why you may be inconvenience.