4

We are using SDL Web 8.1 and we are facing a issue while accessing Keywords inside a Category which takes more then 2 min but before upgrading to Web 8 from 2013 SP1 HR1 it was quite fast.

The Category consist more then 2000 Keywords. We are running the CMS database maintance script regularly (executing first AnalyzeStats.sql and then rebuildindexes.sql script). What could be the reason to load the Keywords very slow?

Please suggest some solution.

  • I am assuming, you are facing issue while accessing keywords inside your web application. Can you share the code snippet which you are using to access the keywords. – Mukesh Kumar Jul 31 '17 at 15:28
  • @MukeshKumar i m facing this issue in SDL Web8 Content Manager Explorer not inside the custom web application. – Abdul Qadir Aug 1 '17 at 7:09
  • Oracle or MSSQL? Do you have DB reports revealing badly optimized queries? – Rick Pannekoek Aug 1 '17 at 19:50
  • We are using Oracle and maintenance task is running regularly – Abdul Qadir Aug 2 '17 at 10:44
  • @MukeshKumar the performance issue reported is regarding SDL Web CME itself and not any external web application. We recently upgraded from 2013 SP1 to Web 8.1 and also added an extra CMS box for load balancing and high availability. Since the upgrade the CME feels slower than compared to 2013 SP1 single CM instance. – Husain Zahid Aug 2 '17 at 11:55
2

We recently had same issue in our one of the environment. but after long analysis we discovered its due to Database. We are using SQL Azure and it was mistakenly configured to Basic Tier. Basic Tier could not handle so much category keyword queries etc so it was taking 2-3 minutes for loading set of keywords.

WE upgraded the azure to high performing tier and performance improved significantly to 5-10 seconds from minutes.

| improve this answer | |
  • RajKumar thanks for your answer but in our scenario we are not using Windows Azure.We are using oracle database and it is in our network only. – Abdul Qadir Aug 2 '17 at 10:48
  • what are your oracle server configurations? – Raj Kumar Aug 2 '17 at 10:57

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.