New features Please use http://kentico.uservoice.com as the primary place to submit your suggestions and allow others to vote for your ideas!
Version 4.x > New features > paging queries View modes: 
User avatar
Member
Member
maciej.zawadowski-universum - 2/21/2009 6:04:15 AM
   
paging queries
I want to increase performance on our portals by implementing paged queries to some repeaters ( here is article describing the idea http://www.codeproject.com/KB/aspnet/PagingGridView.aspx ) . Do anyone have some ideas how to use this solution with Kentico ?

PS: I know that kentico has its own paging system in datareapeters . However most of the time repeters use query like "select * from something" and paging queries are 100% faster if you use it with large dataset .

User avatar
Kentico Developer
Kentico Developer
kentico_helenag - 3/3/2009 5:55:44 AM
   
RE:paging queries
Hello,

Unfortunately, paged queries are not supported by Kentico. You would need to develop such functionality by yourself. I would recommend you to create your special web parts – please see here for some example of creating a web part: http://devnet.kentico.com/docs/devguide/developing_web_parts.htm

You could use the mentioned sample from codeproject.com. You could select the data from the database – I would recommend you to extract the data from views: “View_CONTENT_<code name of document type>_Joined”. There is all data which relates to documents of appropriate type.

Best regards,
Helena Grulichova