Sql Mobile Performance

[Damon Payne]

SqlCE performance is probably one of the most compelling reasons to
move to CF2/Sql Mobile. I have observed most operations as at least
100% faster than the same code on SQL CE, while INSERT operations are
up to 12 times faster.
Has anyone else made any specific observations regarding the
performance of Sql Mobile vs. Sql Ce 2?




Damon
http://www.damonpayne.com/

 

[Ginny Caughey [MVP]]

Damon,

I'd also add that the SqlCeResultSet approach to working with SQL Mobile is
even faster than using the data adapter.

Ginny Caughey
..Net Compact Framework MVP

 

[Damon Payne]

Ginny, I haven't gotten that far in my perf testing yet. I started
doing these tests so that I had some hard metrics to quote rather than
going to my clients with "Word on the street is its faster, so you
should pay me to port your app over"; the results are on my blog for
anyone to use or refute, I'd welcome any other ideas for things to
benchmark.

SqlCeResultSet is in my next round of testing, as well as some
general Winforms drawing performance, file IO, and WebService
performance.

Damon
http://www.damonpayne.com/

 

[Ginny Caughey [MVP]]

Damon,

I look forward to seeing your results. I haven't done any benchmarking
myself, but the performance improvement is definitely noticeable.

Ginny

 

[Guest]

DP- [2 May 2005 11:50:33 -0700]:

doing these tests so that I had some hard metrics to quote rather than
going to my clients with "Word on the street is its faster, so you
should pay me to port your app over"; the results are on my blog for
anyone to use or refute, I'd welcome any other ideas for things to

It's sort of funny -- there you are with charts that
are labelled in the 1000s of seconds, and appear to
take that long, and here this is,

http://gt40.40th.com/bench_gt40_arm.html

with much larger data sets (500% larger, to start), yet showing
sub-second results (easily 1 million percent faster). And even
on a smartphone...(LOL now -- I can't help it).

 

[Chris Tacke, eMVP]

And again if you had a managed class wrapper for it it might be useful for
managed developers. Without that it's like telling a bus driver that your
Ferrari has better 0-60 times. So what? For many developers who have to
get their product to market in a reasonable period of time, an engine that's
a billion times faster isn't useful if you can't do SQL queries, data bind,
or get a managed DataSet

--
Chris Tacke
Co-founder
OpenNETCF.org
Has OpenNETCF helped you? Consider donating to support us!
http://www.opennetcf.org/donate

DP- [2 May 2005 11:50:33 -0700]:

doing these tests so that I had some hard metrics to quote rather than
going to my clients with "Word on the street is its faster, so you
should pay me to port your app over"; the results are on my blog for
anyone to use or refute, I'd welcome any other ideas for things to

It's sort of funny -- there you are with charts that
are labelled in the 1000s of seconds, and appear to
take that long, and here this is,

http://gt40.40th.com/bench_gt40_arm.html

with much larger data sets (500% larger, to start), yet showing
sub-second results (easily 1 million percent faster). And even
on a smartphone...(LOL now -- I can't help it).
--
40th Floor - Software @ http://40th.com/
iPlay : the ultimate audio player for PPCs
mp3,mp4,m4a,aac,ogg,flac,wav,play & record
parametric eq, xfeed, reverb: all on a ppc

 

[Damon Payne]

I thought the observations were Pertinent to this group. I've been
mostly lurking in this group for a couple of years and have read
countless "SQL CE performance is so bad can anyone help?" posts.

 

[Chris Tacke, eMVP]

SQLCE observationns are pertinent. Performance of a data engine that is
unusable by a CF developer I don't think are. If it's not achievable in
your environment, how is it relevant? Don't get me wrong, his numbers are
impressive and I don't dispute them. I also think it would be very
beneficial to managed develoepr if they could use his engine, but as it
stands it's not usable by managed developers so telling us how blazing fast
it is has no relevance.


--
Chris Tacke
Co-founder
OpenNETCF.org
Has OpenNETCF helped you? Consider donating to support us!
http://www.opennetcf.org/donate