Re: Performance SQL Server Mobile with WM 5.0 CF2.0

Hello chris,

When you specify all rows, you may get very large data indeed and copying it around does take some time. Try to select only the rows you absolutely need for the job.

Regards,
João Paulo Figueira
Device Application Development MVP

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



.

Relevant Pages