Kentico Admin very slow

Leann Chowdhury asked on October 17, 2017 00:04

Hi there,

Was wondering if you have any advice regarding a website slowing down in Kentico Admin Panel.

It used to perform fairly quick now its very slow even moving a page or copying it etc.

Anyone have advice?

Cheers Leann

Recent Answers


Brenden Kehren answered on October 17, 2017 00:27

What version are you on? You said it was running fast now it's not. Did you do any recent code pushes or database changes?

0 votesVote for this answer Mark as a Correct answer

Leann Chowdhury answered on October 17, 2017 01:13

Hi Brenden,

Thanks for getting back to me so soon. We are running version v8.2.23, there have not been any recent code pushes or database changes. We do have a lot of old archived data perhaps this is slowing it down.

Cheers Leann

0 votesVote for this answer Mark as a Correct answer

Brenden Kehren answered on October 17, 2017 05:24

So I'd have your DBA run a few queries against the database and take a look at how large the database is, which tables are the biggest offenders, then read the articles below.

For some great details on what to look for and clean up, take a look at fellow Kentico MVP, Brian McKeiver's blog posts:

http://www.mcbeev.com/Blog/April-2015/11-Spring-Cleaning-Tips-for-Your-Kentico-Website

http://www.mcbeev.com/Blog/April-2015/11-Spring-Cleaning-Tips-for-Your-Kentico-Website-Part-2

0 votesVote for this answer Mark as a Correct answer

Brenden Kehren answered on October 19, 2017 14:50

Leann, were you able to query the database to see which tables could be large? Performance of an 8.2 site should be fairly good. Starting with looking at the table size is typically the first thing I do. Second thing is the configuration of the site.

Is it properly configured from a settings standpoint?

If the slowness is only in the Pages application, are the webparts and page templates properly configured? Meaning, do you have all the properties filled out which need to be filled out. For instance, we recently worked on a project where the client had about 10 universal viewers on the master page displaying the data from the currently selected page.

In the universal viewer the only property set was the transformation. If you read the property tool tips, you'll find out the universal viewer will create and run a huge query against all the page types if the page type is not defined. The Kentico Admin UI pages were taking between 4 and 5 minutes to load, generating about 185MB of data on one query and another 65MB of data on another query for each page load. Once I changed those universal viewers out to static text webparts with macros for data retrieval, the Kentico Admin UI pages loaded in less than 5 seconds.

0 votesVote for this answer Mark as a Correct answer

   Please, sign in to be able to submit a new answer.