Performance SQL Server Mobile with Windows Mobile 5.0 CF2.0

[Guest]

Hello,

an SQL-Select on a SQL Server Mobile Databse (Select t1.* from Table t1)
takes about 4 seconds (50 Rows) !!!

I tried using the SqlCeDataAdapter and SqlCeResultSet. But same Performance
Problems.

The pocketpc CPU is a Intel PXA270 with 520 MHZ, 64MB Ram and 128 MB Flash.

Someone had same Perfomace Problems??

Chris

 

[Peter Morris [Droopy eyes software]]

I found the performance was crap, I switched to SQLite instead. The app ran
faster and the footprint is smaller too.

 

[Guest]

We have to use SQl_Server Mobile DB, so i need some hints ....

 

[Guest]

If you're going to do a select * (to which I would suggest you do not, and
name each column you are selecting from instead), why not do (SELECT * FROM
t1) ?

Where is your .sdf file? On the device or on a storage card?
A bit more data about your schema might be helpful as well (# columns, etc).

 

[Pete Vickers [MVP]]

Hi,
takes 4 seconds to do what - read and display?
If displaying, what are you using to display?

Pete

 

[Guest]

The .sdf file is on the device.

If i do the select in the query analyzer the perfomance is good, but under
VS2005 project it takes about 4 seconds. When i debug my application the
trace-debug is very slow too. Is that a normal behaviour on WM 5.0 project?
A Select from Notrhwind.sdf shows the same bad performance.

Any ideas?

 

[Guest]

Hi,

it takes 4 sec to read without displaying.
The Connection ist still open.

Dim da As New SqlCeDataAdapter("Select t1.Field1, t1.Field2 from Table t1",
SqlConnection)

Dim ds As New DataSet()
da.Fill(ds)

chris