Performances issues with SQL Mobile 2005

[Steve B.]

Hi,

We built an application based on Sql CE 2.0 and CF 1.0 a few monh ago. This
application had acceptable performances and went to production.

Now we are converting the app to a CF 2.0 and Sql Mobile version. The
conversion was quite easy with VS 2005 and the application stills works...
but with a very lower performance.
Times to respond is from 1.5 to 10 times slower. The application did not
changed (except VS 2003->VS 2005 conversion) and the DB model was kept
original (from a merge replication).

We checked that indexes has correctly set up, but the application is still
very slow.

Is there any best practice (or bad practices to avoid), or performance tips,
tuning options, etc. that can help us ?

Thanks in advance,
Steve

 

[Darren Shaffer]

SQL Mobile has a new query processor, new storage engine, etc and in general
can be made to outperform SQL CE. There's no global switch to improve
performance,
so you really have to work off the db interactions that are now slower, one
by one.
Avoiding ntext types, use of the SqlCeResultSet, use of TableDirect, etc are
all strategies to explore.

Here is a great preso on tuning SQL CE that is also valid for SQL Mobile
http://24.17.112.250/SQLMobileWebCasts/mbl348.wmv

--
Darren Shaffer
..NET Compact Framework MVP
Principal Architect
Connected Innovation
www.connectedinnovation.com