| info@it-design.biz 2006-03-07, 7:24 am |
| Hi!
I migrated an application von CF1.1 SQL Server CE to CF2.0 and SQL
Mobile 2005
The nice thing is that the time needed for many inserts (especially
with WM 5.0 and ROM devices) seems to be much faster.
But I got an other problem with some selects.
I got an table with about 13.000 records.
When I run a simple select with 10 fields, no joins, groups, just a
where and an order , and a result of something about 20 records the
select takes on a Pocker PC with WinCE 2004 2nd about 2 Seconds and on
WinMobile 5 about 15 Seconds.
Select looks like this (Select Field1,Field2,....Field10 from Table
where Key = ' 33432232' and key2 =' 131242173' order by Field 4 asc ,
field8 asc)
The keyfields are index with an simple not unique index
I must also say that the WM Device has only 5 MB ROM and 5 MB RAM left
and the WinCE Device (Asus MyPal) has plenty of FlashRAM (24 RAM and 25
to write data assigned)
The select ist done with an SqlCeDataAdapter which fills an DataSet.
The DataAdapter is prepared()
So what to do to decrease this big difference. I know that ROM is
slower but that much on an read operation ? On smaller tables thing are
going faster.
Is the problem that there is so less space left ?
Is there an better (Faster) way to get data than with an
SqlCeDataAdapter?
Thank you all very much in advance!
|