Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > Re: Webservice Performance Issue

Reply
Thread Tools

Re: Webservice Performance Issue

 
 
WJ
Guest
Posts: n/a
 
      07-02-2004
"dinoo"

> This webmethod has the implementation of getting all the data in one shot.
>

You may look into the logic of data collection here such as evaluating
number of I/O or DB calls to/from database. Are the target database tables
indexed...Does your data have to be real time ? If not, you may consider a
scheduled job that does just this: Gathers all the needed data in one pot in
advanced and have the web method zero in this pot and does just one DB Read
and serves the client.

> But we are running in a problem that the data which is being transfered in

new application is going around 1 MB.
1MB is nothing! Is it XML or Dataset ? I noticed that Dataset is somewhat
faster but I could be wrong here. Does your client have to wait for this
process to complete before other tasks can be requested ? If not, you may
think of Asyncronous call instead.

John


 
Reply With Quote
 
 
 
 
=?Utf-8?B?ZGlub28=?=
Guest
Posts: n/a
 
      07-02-2004
Tuning the database calls or code is other issue.

My concern is if both application using the same no of calls to database and same code except the new application makes one call and gets the data in one shot then i feel it should be atleast faster than the previous application which use to make 15 calls to get this data.

I could not understand why the new application is not faster than the previous application?

Thanks

Dinesh


"WJ" wrote:

> "dinoo"
>
> > This webmethod has the implementation of getting all the data in one shot.
> >

> You may look into the logic of data collection here such as evaluating
> number of I/O or DB calls to/from database. Are the target database tables
> indexed...Does your data have to be real time ? If not, you may consider a
> scheduled job that does just this: Gathers all the needed data in one pot in
> advanced and have the web method zero in this pot and does just one DB Read
> and serves the client.
>
> > But we are running in a problem that the data which is being transfered in

> new application is going around 1 MB.
> 1MB is nothing! Is it XML or Dataset ? I noticed that Dataset is somewhat
> faster but I could be wrong here. Does your client have to wait for this
> process to complete before other tasks can be requested ? If not, you may
> think of Asyncronous call instead.
>
> John
>
>
>

 
Reply With Quote
 
 
 
 
=?Utf-8?B?ZGlub28=?=
Guest
Posts: n/a
 
      07-02-2004
Tuning the database calls or code is other issue.

My concern is if both application using the same no of calls to database and same code except the new application makes one call and gets the data in one shot then i feel it should be atleast faster than the previous application which use to make 15 calls to get this data.

I could not understand why the new application is not faster than the previous application?

Thanks

Dinesh


"WJ" wrote:

> "dinoo"
>
> > This webmethod has the implementation of getting all the data in one shot.
> >

> You may look into the logic of data collection here such as evaluating
> number of I/O or DB calls to/from database. Are the target database tables
> indexed...Does your data have to be real time ? If not, you may consider a
> scheduled job that does just this: Gathers all the needed data in one pot in
> advanced and have the web method zero in this pot and does just one DB Read
> and serves the client.
>
> > But we are running in a problem that the data which is being transfered in

> new application is going around 1 MB.
> 1MB is nothing! Is it XML or Dataset ? I noticed that Dataset is somewhat
> faster but I could be wrong here. Does your client have to wait for this
> process to complete before other tasks can be requested ? If not, you may
> think of Asyncronous call instead.
>
> John
>
>
>


"WJ" wrote:

> "dinoo"
>
> > This webmethod has the implementation of getting all the data in one shot.
> >

> You may look into the logic of data collection here such as evaluating
> number of I/O or DB calls to/from database. Are the target database tables
> indexed...Does your data have to be real time ? If not, you may consider a
> scheduled job that does just this: Gathers all the needed data in one pot in
> advanced and have the web method zero in this pot and does just one DB Read
> and serves the client.
>
> > But we are running in a problem that the data which is being transfered in

> new application is going around 1 MB.
> 1MB is nothing! Is it XML or Dataset ? I noticed that Dataset is somewhat
> faster but I could be wrong here. Does your client have to wait for this
> process to complete before other tasks can be requested ? If not, you may
> think of Asyncronous call instead.
>
> John
>
>
>

 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem! webservice.htc calling nonsecure webservice from a secured ssl https webpage batista ASP .Net 1 01-26-2006 12:05 PM
Problem! webservice.htc calling nonsecure webservice from a secured ssl https webpage batista ASP .Net 0 01-26-2006 08:13 AM
Re: Webservice Performance Issue Kevin Spencer ASP .Net 4 07-06-2004 01:40 PM
Re: Webservice Performance Issue Steve Drake ASP .Net 0 07-05-2004 04:20 PM
WebService on Java server versus WebService on .NET Mr. x Java 2 10-09-2003 11:21 PM



Advertisments