Hi,
I'm new to WebServices, and I'm doing some tests (with a small
VB.NET-application) to know the performance-difference between a WebService
and the 'normal'-way of getting data (just connecting directly with a
SqlDataAdapter to the SQL Server). The WebMethod simply gives a DataSet
back, and does exactly the same actions as the normal-Method does.
The difference are enormous in my opinion:
1 record:
WebService: 0,03125 seconds
Normal: 0,0156 seconds ->only 50% of WebService
10 records:
WebService: 0,0468 seconds
Normal: 0,016 seconds -> only 33,33% of WebService
100 records:
WebService: 0,125 seconds
Normal: 0,0156 seconds -> only 12,5% of WebService
1000 records:
WebService: 1,14 seconds
Normal: 0,93 seconds -> only 8,22% of WebService
How does this come? The webservice is even local! So I guess it will take
much more time when it wil be on another Server...
Is there a way to have a better performance? and why using WebServices if
they score so bad in performance?
Thanks a lot in advance for any hints etc
Pieter
14  2427 
1. Do your tests in a loop 100 times. Or 1000 times. That will be more
accurate.
2. Web services take time because the request has to be packaged and sent.
Data has to be serialized and deserialized. Requests have to be processed
and responses sent. Even if it all on the same machine.
But yes, calling a web service will always be slower then executing code
directly. That is why you don't want to do it unless your application
requires it.
"DraguVaso" <pi**********@hotmail.com> wrote in message
news:Od**************@TK2MSFTNGP10.phx.gbl... Hi,
I'm new to WebServices, and I'm doing some tests (with a small
VB.NET-application) to know the performance-difference between a
WebService
and the 'normal'-way of getting data (just connecting directly with a
SqlDataAdapter to the SQL Server). The WebMethod simply gives a DataSet
back, and does exactly the same actions as the normal-Method does.
The difference are enormous in my opinion:
1 record:
WebService: 0,03125 seconds
Normal: 0,0156 seconds ->only 50% of WebService
10 records:
WebService: 0,0468 seconds
Normal: 0,016 seconds -> only 33,33% of WebService
100 records:
WebService: 0,125 seconds
Normal: 0,0156 seconds -> only 12,5% of WebService
1000 records:
WebService: 1,14 seconds
Normal: 0,93 seconds -> only 8,22% of WebService
How does this come? The webservice is even local! So I guess it will take
much more time when it wil be on another Server...
Is there a way to have a better performance? and why using WebServices if
they score so bad in performance?
Thanks a lot in advance for any hints etc
Pieter
1. Do your tests in a loop 100 times. Or 1000 times. That will be more
accurate.
2. Web services take time because the request has to be packaged and sent.
Data has to be serialized and deserialized. Requests have to be processed
and responses sent. Even if it all on the same machine.
But yes, calling a web service will always be slower then executing code
directly. That is why you don't want to do it unless your application
requires it.
"DraguVaso" <pi**********@hotmail.com> wrote in message
news:Od**************@TK2MSFTNGP10.phx.gbl... Hi,
I'm new to WebServices, and I'm doing some tests (with a small
VB.NET-application) to know the performance-difference between a
WebService
and the 'normal'-way of getting data (just connecting directly with a
SqlDataAdapter to the SQL Server). The WebMethod simply gives a DataSet
back, and does exactly the same actions as the normal-Method does.
The difference are enormous in my opinion:
1 record:
WebService: 0,03125 seconds
Normal: 0,0156 seconds ->only 50% of WebService
10 records:
WebService: 0,0468 seconds
Normal: 0,016 seconds -> only 33,33% of WebService
100 records:
WebService: 0,125 seconds
Normal: 0,0156 seconds -> only 12,5% of WebService
1000 records:
WebService: 1,14 seconds
Normal: 0,93 seconds -> only 8,22% of WebService
How does this come? The webservice is even local! So I guess it will take
much more time when it wil be on another Server...
Is there a way to have a better performance? and why using WebServices if
they score so bad in performance?
Thanks a lot in advance for any hints etc
Pieter
Thanks!
And isn't there any way to to speed things up a little bit? The fact is: in
my case it could be helpfull, because it should be used by our own people
(Windows Forms application), and give a consultancy-option to our Clients
(Web interface).
But why are people giving such an importance to XML Webservices? I know some
big software-companies that pass everything by a WebServices, even local
Windows forms applications. I was alreaddy sceptic about the technique, but
now I am even more sceptic to use it... :-/
"DraguVaso" <pi**********@hotmail.com> wrote in message
news:Od**************@TK2MSFTNGP10.phx.gbl... Hi,
I'm new to WebServices, and I'm doing some tests (with a small
VB.NET-application) to know the performance-difference between a
WebService
and the 'normal'-way of getting data (just connecting directly with a
SqlDataAdapter to the SQL Server). The WebMethod simply gives a DataSet
back, and does exactly the same actions as the normal-Method does.
The difference are enormous in my opinion:
1 record:
WebService: 0,03125 seconds
Normal: 0,0156 seconds ->only 50% of WebService
10 records:
WebService: 0,0468 seconds
Normal: 0,016 seconds -> only 33,33% of WebService
100 records:
WebService: 0,125 seconds
Normal: 0,0156 seconds -> only 12,5% of WebService
1000 records:
WebService: 1,14 seconds
Normal: 0,93 seconds -> only 8,22% of WebService
How does this come? The webservice is even local! So I guess it will take
much more time when it wil be on another Server...
Is there a way to have a better performance? and why using WebServices if
they score so bad in performance?
Thanks a lot in advance for any hints etc
Pieter
Thanks!
And isn't there any way to to speed things up a little bit? The fact is: in
my case it could be helpfull, because it should be used by our own people
(Windows Forms application), and give a consultancy-option to our Clients
(Web interface).
But why are people giving such an importance to XML Webservices? I know some
big software-companies that pass everything by a WebServices, even local
Windows forms applications. I was alreaddy sceptic about the technique, but
now I am even more sceptic to use it... :-/
"DraguVaso" <pi**********@hotmail.com> wrote in message
news:Od**************@TK2MSFTNGP10.phx.gbl... Hi,
I'm new to WebServices, and I'm doing some tests (with a small
VB.NET-application) to know the performance-difference between a
WebService
and the 'normal'-way of getting data (just connecting directly with a
SqlDataAdapter to the SQL Server). The WebMethod simply gives a DataSet
back, and does exactly the same actions as the normal-Method does.
The difference are enormous in my opinion:
1 record:
WebService: 0,03125 seconds
Normal: 0,0156 seconds ->only 50% of WebService
10 records:
WebService: 0,0468 seconds
Normal: 0,016 seconds -> only 33,33% of WebService
100 records:
WebService: 0,125 seconds
Normal: 0,0156 seconds -> only 12,5% of WebService
1000 records:
WebService: 1,14 seconds
Normal: 0,93 seconds -> only 8,22% of WebService
How does this come? The webservice is even local! So I guess it will take
much more time when it wil be on another Server...
Is there a way to have a better performance? and why using WebServices if
they score so bad in performance?
Thanks a lot in advance for any hints etc
Pieter
Hello DraguVaso, Thanks!
And isn't there any way to to speed things up a little bit? The fact
is: in
my case it could be helpfull, because it should be used by our own
people
(Windows Forms application), and give a consultancy-option to our
Clients
(Web interface).
But why are people giving such an importance to XML Webservices?
Web services offer service consumers a standard way to consume the services
from the service providers in a platform agnostic manner. Before the emergence
of WS, we were to provide our clients with dlls, proxy software etc so that
they can consume our services. Again we had to maintain multiple setups for
clients with different platforms. As web services use industry accepted protocols
for data messaging and transport bindings, we are relieved from the pain
of maintaing client specific infrasture at the service provider end.
As the message are transported in the form of XML, they are serialized at
the server side and deserialized at the client end and they are transported
currently over http and are bound to be slow.
If you are .NET client you can speed up your perception of speed by using
Async web methods.
I know some big software-companies that pass everything by a
WebServices, even local Windows forms applications. I was alreaddy
sceptic about the technique, but now I am even more sceptic to use
it... :-/
"DraguVaso" <pi**********@hotmail.com> wrote in message
news:Od**************@TK2MSFTNGP10.phx.gbl...
Hi,
I'm new to WebServices, and I'm doing some tests (with a small
VB.NET-application) to know the performance-difference between a
WebService
and the 'normal'-way of getting data (just connecting directly with a
SqlDataAdapter to the SQL Server). The WebMethod simply gives a
DataSet
back, and does exactly the same actions as the normal-Method does.
The difference are enormous in my opinion:
1 record:
WebService: 0,03125 seconds
Normal: 0,0156 seconds ->only 50% of WebService
10 records:
WebService: 0,0468 seconds
Normal: 0,016 seconds -> only 33,33% of WebService
100 records:
WebService: 0,125 seconds
Normal: 0,0156 seconds -> only 12,5% of WebService
1000 records:
WebService: 1,14 seconds
Normal: 0,93 seconds -> only 8,22% of WebService
How does this come? The webservice is even local! So I guess it will
take
much more time when it wil be on another Server...
Is there a way to have a better performance? and why using
WebServices if
they score so bad in performance?
Thanks a lot in advance for any hints etc
Pieter
Hello DraguVaso, Thanks!
And isn't there any way to to speed things up a little bit? The fact
is: in
my case it could be helpfull, because it should be used by our own
people
(Windows Forms application), and give a consultancy-option to our
Clients
(Web interface).
But why are people giving such an importance to XML Webservices?
Web services offer service consumers a standard way to consume the services
from the service providers in a platform agnostic manner. Before the emergence
of WS, we were to provide our clients with dlls, proxy software etc so that
they can consume our services. Again we had to maintain multiple setups for
clients with different platforms. As web services use industry accepted protocols
for data messaging and transport bindings, we are relieved from the pain
of maintaing client specific infrasture at the service provider end.
As the message are transported in the form of XML, they are serialized at
the server side and deserialized at the client end and they are transported
currently over http and are bound to be slow.
If you are .NET client you can speed up your perception of speed by using
Async web methods.
I know some big software-companies that pass everything by a
WebServices, even local Windows forms applications. I was alreaddy
sceptic about the technique, but now I am even more sceptic to use
it... :-/
"DraguVaso" <pi**********@hotmail.com> wrote in message
news:Od**************@TK2MSFTNGP10.phx.gbl...
Hi,
I'm new to WebServices, and I'm doing some tests (with a small
VB.NET-application) to know the performance-difference between a
WebService
and the 'normal'-way of getting data (just connecting directly with a
SqlDataAdapter to the SQL Server). The WebMethod simply gives a
DataSet
back, and does exactly the same actions as the normal-Method does.
The difference are enormous in my opinion:
1 record:
WebService: 0,03125 seconds
Normal: 0,0156 seconds ->only 50% of WebService
10 records:
WebService: 0,0468 seconds
Normal: 0,016 seconds -> only 33,33% of WebService
100 records:
WebService: 0,125 seconds
Normal: 0,0156 seconds -> only 12,5% of WebService
1000 records:
WebService: 1,14 seconds
Normal: 0,93 seconds -> only 8,22% of WebService
How does this come? The webservice is even local! So I guess it will
take
much more time when it wil be on another Server...
Is there a way to have a better performance? and why using
WebServices if
they score so bad in performance?
Thanks a lot in advance for any hints etc
Pieter
DraguVaso wrote:
[snip] But why are people giving such an importance to XML Webservices? I
Because it has an X in its name :-(
Andrew
DraguVaso wrote:
[snip] But why are people giving such an importance to XML Webservices? I
Because it has an X in its name :-(
Andrew
Do you remember when everybody was talking about IA engines ;-) I meant that
"hot stuff" is discussed likely more without necessarily reflecting real
use.
You could try a monitoring tool to make sure it goes into serializing/http
transmission/deserializing. By constrast ADO.NET uses the native SQL Server
protocol.
For now it doesn't look that bad to me. IMO the real question is how much
often do you need to call this ?
It greatly depends on the kind of application you are writing (for some
applications you could even use a "checkout", "checkin" model that would
allow to work locally a while before making new data available).
In any case you are not forced to use web services if this is not needed...
--
Patrice
"Andrew Morton" <ak*@in-press.co.uk.invalid> a écrit dans le message de
news:eN**************@tk2msftngp13.phx.gbl... DraguVaso wrote:
[snip] But why are people giving such an importance to XML Webservices? I
Because it has an X in its name :-(
Andrew
Do you remember when everybody was talking about IA engines ;-) I meant that
"hot stuff" is discussed likely more without necessarily reflecting real
use.
You could try a monitoring tool to make sure it goes into serializing/http
transmission/deserializing. By constrast ADO.NET uses the native SQL Server
protocol.
For now it doesn't look that bad to me. IMO the real question is how much
often do you need to call this ?
It greatly depends on the kind of application you are writing (for some
applications you could even use a "checkout", "checkin" model that would
allow to work locally a while before making new data available).
In any case you are not forced to use web services if this is not needed...
--
Patrice
"Andrew Morton" <ak*@in-press.co.uk.invalid> a écrit dans le message de
news:eN**************@tk2msftngp13.phx.gbl... DraguVaso wrote:
[snip] But why are people giving such an importance to XML Webservices? I
Because it has an X in its name :-(
Andrew
hi
My opinin is different time is not at all issue for today's high speed
processor.
you can compromise time by compatible hardware.but in future if you need to
built onother application for your company then you can use existing web
services and devlopment will be faster
--
Have A Good Day,
Mahesh, Ma************@yahoo.co.in
"DraguVaso" wrote: Thanks!
And isn't there any way to to speed things up a little bit? The fact is: in
my case it could be helpfull, because it should be used by our own people
(Windows Forms application), and give a consultancy-option to our Clients
(Web interface).
But why are people giving such an importance to XML Webservices? I know some
big software-companies that pass everything by a WebServices, even local
Windows forms applications. I was alreaddy sceptic about the technique, but
now I am even more sceptic to use it... :-/
"DraguVaso" <pi**********@hotmail.com> wrote in message
news:Od**************@TK2MSFTNGP10.phx.gbl... Hi,
I'm new to WebServices, and I'm doing some tests (with a small
VB.NET-application) to know the performance-difference between a
WebService
and the 'normal'-way of getting data (just connecting directly with a
SqlDataAdapter to the SQL Server). The WebMethod simply gives a DataSet
back, and does exactly the same actions as the normal-Method does.
The difference are enormous in my opinion:
1 record:
WebService: 0,03125 seconds
Normal: 0,0156 seconds ->only 50% of WebService
10 records:
WebService: 0,0468 seconds
Normal: 0,016 seconds -> only 33,33% of WebService
100 records:
WebService: 0,125 seconds
Normal: 0,0156 seconds -> only 12,5% of WebService
1000 records:
WebService: 1,14 seconds
Normal: 0,93 seconds -> only 8,22% of WebService
How does this come? The webservice is even local! So I guess it will take
much more time when it wil be on another Server...
Is there a way to have a better performance? and why using WebServices if
they score so bad in performance?
Thanks a lot in advance for any hints etc
Pieter
hi
My opinin is different time is not at all issue for today's high speed
processor.
you can compromise time by compatible hardware.but in future if you need to
built onother application for your company then you can use existing web
services and devlopment will be faster
--
Have A Good Day,
Mahesh, Ma************@yahoo.co.in
"DraguVaso" wrote: Thanks!
And isn't there any way to to speed things up a little bit? The fact is: in
my case it could be helpfull, because it should be used by our own people
(Windows Forms application), and give a consultancy-option to our Clients
(Web interface).
But why are people giving such an importance to XML Webservices? I know some
big software-companies that pass everything by a WebServices, even local
Windows forms applications. I was alreaddy sceptic about the technique, but
now I am even more sceptic to use it... :-/
"DraguVaso" <pi**********@hotmail.com> wrote in message
news:Od**************@TK2MSFTNGP10.phx.gbl... Hi,
I'm new to WebServices, and I'm doing some tests (with a small
VB.NET-application) to know the performance-difference between a
WebService
and the 'normal'-way of getting data (just connecting directly with a
SqlDataAdapter to the SQL Server). The WebMethod simply gives a DataSet
back, and does exactly the same actions as the normal-Method does.
The difference are enormous in my opinion:
1 record:
WebService: 0,03125 seconds
Normal: 0,0156 seconds ->only 50% of WebService
10 records:
WebService: 0,0468 seconds
Normal: 0,016 seconds -> only 33,33% of WebService
100 records:
WebService: 0,125 seconds
Normal: 0,0156 seconds -> only 12,5% of WebService
1000 records:
WebService: 1,14 seconds
Normal: 0,93 seconds -> only 8,22% of WebService
How does this come? The webservice is even local! So I guess it will take
much more time when it wil be on another Server...
Is there a way to have a better performance? and why using WebServices if
they score so bad in performance?
Thanks a lot in advance for any hints etc
Pieter
What do you mean with "compatbile hardware"? :-)
Will my Webservice have much better performance when turning on a real
server (better processor, more ram) than my local pc? Or will the
network-than consume more?
"MAHESH MANDHARE" <ma***************@yahoo.co.in> wrote in message
news:B0**********************************@microsof t.com... hi
My opinin is different time is not at all issue for today's high speed
processor.
you can compromise time by compatible hardware.but in future if you need
to built onother application for your company then you can use existing web
services and devlopment will be faster
--
Have A Good Day,
Mahesh,
Ma************@yahoo.co.in
"DraguVaso" wrote:
Thanks!
And isn't there any way to to speed things up a little bit? The fact is:
in my case it could be helpfull, because it should be used by our own
people (Windows Forms application), and give a consultancy-option to our
Clients (Web interface).
But why are people giving such an importance to XML Webservices? I know
some big software-companies that pass everything by a WebServices, even local
Windows forms applications. I was alreaddy sceptic about the technique,
but now I am even more sceptic to use it... :-/
"DraguVaso" <pi**********@hotmail.com> wrote in message
news:Od**************@TK2MSFTNGP10.phx.gbl... Hi,
I'm new to WebServices, and I'm doing some tests (with a small
VB.NET-application) to know the performance-difference between a
WebService
and the 'normal'-way of getting data (just connecting directly with a
SqlDataAdapter to the SQL Server). The WebMethod simply gives a
DataSet back, and does exactly the same actions as the normal-Method does.
The difference are enormous in my opinion:
1 record:
WebService: 0,03125 seconds
Normal: 0,0156 seconds ->only 50% of WebService
10 records:
WebService: 0,0468 seconds
Normal: 0,016 seconds -> only 33,33% of WebService
100 records:
WebService: 0,125 seconds
Normal: 0,0156 seconds -> only 12,5% of WebService
1000 records:
WebService: 1,14 seconds
Normal: 0,93 seconds -> only 8,22% of WebService
How does this come? The webservice is even local! So I guess it will
take much more time when it wil be on another Server...
Is there a way to have a better performance? and why using WebServices
if they score so bad in performance?
Thanks a lot in advance for any hints etc
Pieter
What do you mean with "compatbile hardware"? :-)
Will my Webservice have much better performance when turning on a real
server (better processor, more ram) than my local pc? Or will the
network-than consume more?
"MAHESH MANDHARE" <ma***************@yahoo.co.in> wrote in message
news:B0**********************************@microsof t.com... hi
My opinin is different time is not at all issue for today's high speed
processor.
you can compromise time by compatible hardware.but in future if you need
to built onother application for your company then you can use existing web
services and devlopment will be faster
--
Have A Good Day,
Mahesh,
Ma************@yahoo.co.in
"DraguVaso" wrote:
Thanks!
And isn't there any way to to speed things up a little bit? The fact is:
in my case it could be helpfull, because it should be used by our own
people (Windows Forms application), and give a consultancy-option to our
Clients (Web interface).
But why are people giving such an importance to XML Webservices? I know
some big software-companies that pass everything by a WebServices, even local
Windows forms applications. I was alreaddy sceptic about the technique,
but now I am even more sceptic to use it... :-/
"DraguVaso" <pi**********@hotmail.com> wrote in message
news:Od**************@TK2MSFTNGP10.phx.gbl... Hi,
I'm new to WebServices, and I'm doing some tests (with a small
VB.NET-application) to know the performance-difference between a
WebService
and the 'normal'-way of getting data (just connecting directly with a
SqlDataAdapter to the SQL Server). The WebMethod simply gives a
DataSet back, and does exactly the same actions as the normal-Method does.
The difference are enormous in my opinion:
1 record:
WebService: 0,03125 seconds
Normal: 0,0156 seconds ->only 50% of WebService
10 records:
WebService: 0,0468 seconds
Normal: 0,016 seconds -> only 33,33% of WebService
100 records:
WebService: 0,125 seconds
Normal: 0,0156 seconds -> only 12,5% of WebService
1000 records:
WebService: 1,14 seconds
Normal: 0,93 seconds -> only 8,22% of WebService
How does this come? The webservice is even local! So I guess it will
take much more time when it wil be on another Server...
Is there a way to have a better performance? and why using WebServices
if they score so bad in performance?
Thanks a lot in advance for any hints etc
Pieter
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: John Bailo |
last post by:
I wrote a webservice to output a report file. The fields of the report
are formatted based on information in an in-memory XmlDocument. As
each row of a SqlDataReader are looped through, a...
|
by: DraguVaso |
last post by:
Hi,
I need to write a VB.NET-application (Windows Forms) that may have a part of
it (re-)implemented as a Webpage for the customers.
I think it can be usefull to create a business Layer with...
|
by: Matt Garman |
last post by:
Is there any difference, performance-wise, accessing elements of a
vector using iterators or the subscript operator?
In other words, say I have a vector of strings:
vector<string> strvec;
...
|
by: Daniel P. |
last post by:
MS or anyone still claims that C# and VB.NET generate the exact same IL
code?
http://www.osnews.com/story.php?news_id=5602&page=3
|
by: Mike |
last post by:
Lets just say my app is done HOO HOO.
Now, I'm accessing the database via a web service and one thing i noticed
that my app is running real slow. When I first started working on the app is
ran...
|
by: Lakshmi |
last post by:
Hi All,
I am having performance issues with the .NET client calling the Java
Webservice running on axis. Have detailed the problem below. Please
help.
I wrote a webservice in Java. Lets name...
|
by: Alexis |
last post by:
Hello,
I have developted a webservice application. The application has a few
webservices each webservice with their own webmethods of course.
I want to measure the performance of my site. I look...
|
by: MuZZy |
last post by:
Hi,
Consider this:
ArrayList al = new ArrayList();
FillList(al);
/// NOW TWO SCENARIOS:
/// 1.
for (int i = 0 ; i < al.Count ; i++)
|
by: Islamegy® |
last post by:
I have a Dynamic Page which alow user to choose User-control from a
DropDownList like in DotNetNuke then i load it using
LoadControl() method. But i suffer from slow Performance, I was use...
|
by: galiorenye |
last post by:
Hi,
Given this code:
A** ppA = new A*;
A *pA = NULL;
for(int i = 0; i < 10; ++i)
{
pA = ppA;
//do something with pA
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
| |
