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. Advertising

  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. Advertising

  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. Advertising

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. Kevin Spencer

    Re: Webservice Performance Issue

    Kevin Spencer, Jul 2, 2004, in forum: ASP .Net
    Replies:
    4
    Views:
    370
    Kevin Spencer
    Jul 6, 2004
  2. Steve Drake

    Re: Webservice Performance Issue

    Steve Drake, Jul 5, 2004, in forum: ASP .Net
    Replies:
    0
    Views:
    893
    Steve Drake
    Jul 5, 2004
  3. batista
    Replies:
    1
    Views:
    940
    Laurent Bugnion
    Jan 26, 2006
  4. batista
    Replies:
    0
    Views:
    575
    batista
    Jan 26, 2006
  5. Mr. x
    Replies:
    2
    Views:
    729
    Andrew
    Oct 10, 2003
Loading...

Share This Page