Page Type VS Custom Tables

kuntesh thakker asked on June 20, 2017 14:16

Which one is good for Large no of documents . I have whitepapers for about 20,000 or can be more . What is best - custom tables or page types . Also i need to add workflow which is only available in page types . Please assist

Recent Answers


Roman Hutnyk answered on June 20, 2017 14:28

Custom table (or custom module class) is good for storing large amount of data, however you can't use workflows/versioning with it. So if workflow is a requirement - go with page type, or you'll have to implement custom workflow for custom table.

1 votesVote for this answer Mark as a Correct answer

Charles Matvchuk answered on June 20, 2017 14:34

If you need your white papers to be in the tree and be part of the url, use page types. I have over 500,000 page types and in Kentico 10 there is no performance degradation.

0 votesVote for this answer Mark as a Correct answer

Brenden Kehren answered on June 20, 2017 15:27

Adding items to the content tree will help with SEO, navigation, search and so on without any additional coding. If you have these items in a custom table or a module class, then you need to write additional code to get the SEO, navigation and search abilities. Some are easier than others but out of the box you won't get ALL the features as you would if you placed them in the content tree.

0 votesVote for this answer Mark as a Correct answer

Sandeep Vadarale answered on June 20, 2017 17:53 (last edited on June 20, 2017 17:54)

Page Types will be better in your case as it helps in many out of box features

0 votesVote for this answer Mark as a Correct answer

Mohd Nayeem answered on October 6, 2017 08:50

You can use event handlers for Publish after in work flow and on published after event handler we have move the page from content to custom tables. In this we can use workflow and save document in custom tables.

0 votesVote for this answer Mark as a Correct answer

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