Re: Database speed

Generally the system volume should be faster, because like you expected, it
is only using RAM instead of writing to flash. If the object store is
nearly full, it's possible that the database operations are causing a
background thread to spin up and do a lot of work to try to compact the
object store to make room. If there is a lot of data in the object store it
could be moving a lot of objects around. That is the only explanation I can
think of right now for why that'd be slower.

Writing a lot of data should not be that painful. It's rewrites and deletes
that are bad, because they free up "holes" inside the volume that then get
compacted; it's all that data reordering that really burns you. Is it
possible she's writing to each record more than once?

Sue
sloh@xxxxxxxxxxxxx (remove "online" from reply-to address)
http://blogs.msdn.com/ce_base/
_____________________________________________________________
This posting is provided "AS IS" with no warranties, and confers no rights.
_____________________________________________________________


.

Relevant Pages

  • Re: Database speed
    ... it may not be the problem of database. ... background thread to spin up and do a lot of work to try to compact the ... object store to make room. ... Writing a lot of data should not be that painful. ...
    (microsoft.public.windowsce.app.development)
  • Re: Temp folder on windows CE
    ... The flash is accessible through - locl drive mounr point. ... that for some reason IE tries to save files in the object store and not ...
    (microsoft.public.windowsce.embedded)