Announcement

Collapse
No announcement yet.

Saved Query on Order Page taking a long time to Fetch the details in 5.5

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Saved Query on Order Page taking a long time to Fetch the details in 5.5

    Hi All,
    There is a issue on the OTM 5.5 where the Saved Query on the Order Page is taking nearly 5 to 10 minutes to fetch the details. The Users are willing to use only the saved query.
    When the same is searched by selecting the options the speed is faster.
    Please suggest on how to take it further. Are is there any recommendations that we can give to the Users.

  • #2
    Re: Saved Query on Order Page taking a long time to Fetch the details in 5.5

    Hi,

    Please check OTM database resources and retrieve AWRR report from database when users are using "Saved Query"

    Thank you


    -Prasad-
    Let's connect on LinkedIn
    Mobile: +91 973 049 6886
    E-mail: prasad.chandane@gmail.com

    If my post was helpful, then click on the Like button

    Comment


    • #3
      Re: Saved Query on Order Page taking a long time to Fetch the details in 5.5

      Hi Prasad,
      Have checked the AWR Report also. On that the details are updating fast. Only on the front end the users are getting it delayed.

      Comment


      • #4
        Re: Saved Query on Order Page taking a long time to Fetch the details in 5.5

        Hi,

        Could you please attach AWRR report here?

        Let us know the full information about Saved Query which is causing performance problems

        Is there any other pages in OTM also had same performance problem?

        Thank you


        -Prasad-

        Let's connect on LinkedIn
        Mobile: +91 973 049 6886
        E-mail: prasad.chandane@gmail.com

        If my post was helpful, then click on the Like button

        Comment


        • #5
          Re: Saved Query on Order Page taking a long time to Fetch the details in 5.5

          Ok if front end display is the issue...you can try this...

          The Order Result Display Screen..has so many fields...now I am sure you/client donot need ALL of those fields to be displayed....(e.g. some are empty..some are of no business sense to you/client). Remove those fields in the screen set and make your results page LITE. This can also enable faster display of 'apt' data on the screen
          Thanks
          Vik

          Comment

          Working...
          X