Repeater item loading performance

Duong Tran asked on April 23, 2015 17:59

Hello,

I'm working on repeater with paging enabled. Now i need to make sure that the page only get only 10 items from DB instead of all.

I was open debug to see the SQL script, but it seems does not contains any function like limit getting data item.

I was also trying to use "load pages individually" property in that control but the result always showing duplicated triple items.

I'm using Kentico 8.1.10

Please help, thanks

Duong

repeater pagination issue repeater

Recent Answers

Rui Wang answered on April 23, 2015 20:20

Are you trying to get 10 in total, or 10 per page?

0 votesVote for this answer Mark as a Correct answer

Charles Matvchuk answered on April 24, 2015 03:34

If you only want to get 10, use TOP (10) in your query.

0 votesVote for this answer Mark as a Correct answer

Juraj Ondrus answered on April 24, 2015 09:56

Hi,

also please check the Columns property - by default all columns are retrieved form the DB - set it to the columns you are using in the transformation, so you will be pulling only the data you need.

0 votesVote for this answer Mark as a Correct answer

Duong Tran answered on April 25, 2015 09:59

Hi,

Thanks for helping me.

I have about 100,000 records (documents) in Kentico, and I have to display list of them in a page, I need to make sure that Universal Pager only get 10 records to display for each page.

I have received the answer from Kentico support that it is only getting only 10 records per page if turn on Load pages individually property of the Data Source.

The problem is the records will be duplicated to triple. Can anybody let me know how to resolve this problem? or some useful case to inspect why it is duplicated.

Thanks, Duong

0 votesVote for this answer Mark as a Correct answer