Webservice performance decrease after technical update

SonGoten13SonGoten13 Member Posts: 44
edited 2012-08-24 in NAV Three Tier
Hi,
I am using Webservices for different communication between 2 classic client databases. They were on R2 Build 6.0.32365.
After an technical update to 6.0.33639 i experience a decrease in performance. I dont have numbers, but they are noticeable slower.
Anyone an idea?

greetings

Answers

  • David_SingletonDavid_Singleton Member Posts: 5,479
    The first step would be to identify if the issue is SQL or the Middle tier. Have a look at queries from the old version and the new version and see if they changed.

    Assuming of course that nothing else changed.
    David Singleton
  • deV.chdeV.ch Member Posts: 543
    Don't know if you're aware of it but on any restart of a webservice or service tier on the first run you experience slow performance, this gets better any execution, this is due to caching & Compilation of metadata and c# code, that must be done first.
    Have you done performance testing after a "warmup" ?
  • SonGoten13SonGoten13 Member Posts: 44
    thx for your responses
    @David: Well i have no queries saved from the old version, and as far as i know it is not possible to reverse a technical update when there was a database conversion, or?
    @deV.ch: Yeah i heard that, but never experienced a noticeable difference after an warmup phase before. I tried it now again, and when executing the same webservice(with different parameters) around 500 times counts as warmup, then it has nothing to do with it.

    But it got already(today i tried around a little bit more) again a bit faster since last week when i first discovered it. Maybe the Server just hat a bad day, i don't know ^^
    Gonna have to monitor it a little bit longer (its not in an production environment yet).
    Comments are anyway appreciated.

    greetings

    Update 01.2015: some time ago already, but as surprisingly as the problem came up it also went away, no idea why though
Sign In or Register to comment.