The flash storage card can be taken out from the device. We have tried our application in the same card on other WinCE devices and the application performance is ok.
The performance degrades only happen on that kind of WinCE devices. Any clue for further investigation? Phua Si Jie wrote: >>* We have used sqlite heavily in our WinCE application. Recently, we *>* encounter tremendously performance degrade on sqlite on some WinCE *devices. > Is it possible that the flash storage on these devices is reaching the end of its useful life (i.e. and now it exhibits somewhat degraded performance due to block relocations, etc)? -- Joe Mistachkin On Mon, Apr 14, 2014 at 3:27 PM, Phua Si Jie <phu...@gmail.com> wrote: > Hi, > > We have used sqlite heavily in our WinCE application. Recently, we > encounter tremendously performance degrade on sqlite on some WinCE devices. > > On a query "select * from SysInfo" which has only 19 records, these slow > units require about 2 seconds to complete the query while other device > require about 0.2 seconds. > > These devices use CPU of "MStart Semiconductor, Cortex-A7-MSB2531". We are > not sure whether the slowness is relevant to CPU type. > > What should be the way to identify the cause and solution of the slowness? > > Best Regards, > Si Jie > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
