Performance - Web Services vs. SQL Mobile

DEVBUZZ Forums 2009

Home Forums Register Login My Profile Inbox Address My Subscription My Forums

Photo Gallery Member List UserGroups List Search Calendars FAQ Tickets Log Out

Performance - Web Services vs. SQL Mobile

View related threads: (in this forum | in all forums)

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> [eMbedded Visual Tools] >> SQL Server for CE Forum >> Performance - Web Services vs. SQL Mobile

Page: [1]

Message

<< Older Topic Newer Topic >>

Performance - Web Services vs. SQL Mobile - 4/12/2006 1:19:50 PM

bsampson

Posts: 7
Joined: 6/11/2004
Status: offline

I'm looking at connecting a mobile device application to a SQL server via 802.11b.

I was going to use web services originally, but in my test, getting results from a simple query is about 12 seconds (development environment in VS2005 using a bluetooth/activesync connection to my pc)! I was then looking at SQL Mobile, but it appears that it also runs through IIS.

Is performance going to be better with SQL Mobile?

Thanks for any insight!

Post #: 1

RE: Performance - Web Services vs. SQL Mobile - 4/12/2006 3:37:16 PM

petevick

Posts: 3471
Joined: 4/26/2002
From: Bolton - UK
Status: offline

Hi,
why not use SqlClient, and access the Sqlserver database directly. I think you may well be surprised by the speed.

Pete

_____________________________

Pete Vickers - Microsoft MVP - Device Application Development
www.gui-innovations.com

Please do not email me with questions. Posting your questions in the forums will get a quicker response - Thanks.

(in reply to bsampson)

Post #: 2

RE: Performance - Web Services vs. SQL Mobile - 4/12/2006 4:39:37 PM

bsampson

Posts: 7
Joined: 6/11/2004
Status: offline

I'm not sure why my web services were so sloooow earlier, but now I'm getting an initial response in about 6 seconds, then following queries are around 1 - 2 seconds.

I tried SQL client and it is definitely faster. In this test it's ranging from .5 to 1.5 seconds.

I'd guess in my environment, in a very basic query, SqlClient is about 50% faster than the web service.

I was thinking about Web Services because I can more centrally manage web service code than code distributed on multiple devices. Plus, I could reuse the web services in applications for PC's as well. 50% is pretty substantial, however. I'll have to test with more realistic queries.

Thanks again Pete.

(in reply to petevick)

Post #: 3

RE: Performance - Web Services vs. SQL Mobile - 4/13/2006 4:26:53 AM

strider

Posts: 446
Joined: 9/7/2004
From: Dublin, Ireland
Status: offline

I have found the also used webservices for a live wireless application.

I found using the webservices good as it allowed me to track what the users where doing and write to a log file an errors that occured

Ya i noticed before that the webservices can be slow the first time you call them because it has to initialise the asp.net applicaiton in the worker process.
But after a webservice was initialised it would run a lot faster

So what i done was to create the instance of the webservice when the forms were loaded. I also done a dummy call on a function .
So that later in the application it would work faster.

_____________________________

Barry

(in reply to bsampson)

Post #: 4

RE: Performance - Web Services vs. SQL Mobile - 12/11/2009 3:19:42 AM

clint

Posts: 80
Joined: 6/14/2005
Status: offline

hello
could someone tell me how to load data from SqlClient to SqlCe?

thanks
Clint

(in reply to strider)

Post #: 5

RE: Performance - Web Services vs. SQL Mobile - 12/11/2009 7:46:36 AM

petevick

Posts: 3471
Joined: 4/26/2002
From: Bolton - UK
Status: offline

You want to populate your SQLCe from Sql?
You can either use a 3rd party (we have a solution), roll your own, or take a look at http://erikej.blogspot.com/2009/10/new-beta-of-exportsqlce-ssms-add-in.html

Ideally, this should be a new topic though :)

_____________________________

Pete Vickers - Microsoft MVP - Device Application Development
www.gui-innovations.com

Please do not email me with questions. Posting your questions in the forums will get a quicker response - Thanks.

(in reply to clint)

Post #: 6