Re: Webservice Performance Issue

Discussion in 'ASP .Net' started by WJ, Jul 2, 2004.

  1. WJ

    WJ Guest

    "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, Jul 2, 2004
    #1
    1. Advertisements

  2. 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
    >
    >
    >
     
    =?Utf-8?B?ZGlub28=?=, Jul 2, 2004
    #2
    1. Advertisements

  3. 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
    >
    >
    >
     
    =?Utf-8?B?ZGlub28=?=, Jul 2, 2004
    #3
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. jm
    Replies:
    1
    Views:
    644
    alien2_51
    Dec 12, 2003
  2. Kevin Spencer

    Re: Webservice Performance Issue

    Kevin Spencer, Jul 2, 2004, in forum: ASP .Net
    Replies:
    4
    Views:
    541
    Kevin Spencer
    Jul 6, 2004
  3. batista
    Replies:
    1
    Views:
    1,139
    Laurent Bugnion
    Jan 26, 2006
  4. Nikolay S

    WebService Performance Problem

    Nikolay S, Jul 8, 2003, in forum: ASP .Net Web Services
    Replies:
    2
    Views:
    215
    Nikolay S
    Jul 10, 2003
  5. Mirco Kaffsach

    WebService Performance...

    Mirco Kaffsach, Nov 24, 2003, in forum: ASP .Net Web Services
    Replies:
    2
    Views:
    173
    Mirco Kaffsach
    Nov 25, 2003
  6. Sunil Menon

    Monitor WebService performance

    Sunil Menon, Jan 2, 2004, in forum: ASP .Net Web Services
    Replies:
    3
    Views:
    209
    ricko70
    Jan 7, 2004
  7. terry17

    Performance of the WebService

    terry17, Apr 11, 2005, in forum: ASP .Net Web Services
    Replies:
    1
    Views:
    169
    Tu-Thach
    Apr 12, 2005
  8. Software Engineer
    Replies:
    0
    Views:
    511
    Software Engineer
    Jun 10, 2011
Loading...