D
DraguVaso
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
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