Login to See You Blogs
Login to Write

Home Forums Unanswered Question

Viewing 4 topics - 1 through 4 (of 4 total)
    • Topic
    • Voices
    • Resourcess
    • Freshness
    • Performance enhancement of Axpert apps

      Views: 213

    • 1
    • 1
    • 11 months, 2 weeks ago

    • In one of the application the analysis report takes 75 seconds to open. The definition pattern is given below.

      – This is an interface transaction for Taking Analytical Reports.
      – Have 30 combo box. ( the customer want combo box only ).
      – All fields are dependent to previous field(s). ( second field have one parameter and third field have 2 parameter and fourth field have 3 parameter vice versa….)
      – All fields has default value in expression.
      – The same table name are being used in all fields.
      – When open the transaction all fields SQL are firing because of inter dependent through Get dependent web service.
      – Some SQL taking long time but really that is not a case(i.e.) when run those SQL in SQL developer it runs in very few milliseconds. This is also happening inconsistently. (i.e) in first time trace it points 10th SQL , next time it may be 10th or 15th SQL like this.

      I guessed this is because of same table is used in different fields so separate Materialized views are created and applied in SQL. Now the transaction is opened 03 to 04 seconds as usual.

      is it platform related or DB caching mechanism needs to be audit by DBA.

      11 months, 2 weeks ago
Viewing 4 topics - 1 through 4 (of 4 total)