How can I reduce database load in Umbraco 17? Any tables safe to clean up or remove?

Questions
1

Hi everyone,
I’m running Umbraco 17 and I’d like to reduce the overall load on the database. Do you have any recommendations on what can be safely limited, cleaned up, or removed?

Specifically:

  • Are there features or data types that tend to generate unnecessary database load?
  • Does the new persistence system in Umbraco 17 provide better performance out of the box, or are there any settings I should tweak?
  • Are there old or legacy tables (from previous Umbraco versions) that can or should be manually removed when upgrading?
  • Any best-practice tips for keeping the database lean and fast?

Thanks in advance for any guidance!

2

Those are some good questions!

I’m sure you are aware, but in case not, Umbraco is using HybridCache since v15 and it is important to configure that properly:

Thinks to look into:

  • Are you seeding correctly and have identified most-viewed document types in Umbraco:CMS:Cache:ContentTypeKeys?
  • Is your seed count set appropriately, fx with DocumentBreadthFirstSeedCount
  • Do your documents fit in the cache at all? Make sure MaximumPayloadBytes is set appropriately.

There are some other tricks to increase page size and stuff, and some other tidbits in here such as make sure not to “over-query” lists:

Many other goodies in that article, too.

Hope that helps a bit.

1 Like
3

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.