CE5.0 poor Sql performance

  • Thread starter Thread starter intelinside
  • Start date Start date
I

intelinside

Hi to all,

i have a CE5.0 device with CF 2.01 and SQL Mobile 5.0 (ce 3.0).
The SDF is located on a integrated Flash Fx disk and the initial size
is 57kb

I use a TableAdapters & XML typed dataset to queryng my database.

The insert time of 1 record in 1 table is 1/2 seconds !!!!

The same application, same database on a CE4.2 device with a Diskonchip
integrated device the insert time of 1 record in 1 table is 0.04
seconds !!!

Why this ?

Thanx in advance!
 
If the flash is NOR (required for XIP), then it's fast to read, but slow to
write. The other device could have been using NAND flash, which is fast to
write, but slower to read. The driver for the media can also have a huge
impact of performance (if and how they do waer leveling, etc).
 
Back
Top