Site structure
Version 4.x > Site structure > Using Indexed View for performance View modes: 
User avatar
Member
Member
ASI-fujibikes - 10/27/2009 6:32:29 PM
   
Using Indexed View for performance
Hi all,

Has anyone tried creatina a indexed view on all the views that are created by Kentico.

After research i believe since kentico gets most of its stuff from views, but some times views are not indexed...but if we can create an indexed view it would help a lot, infact it would be superfast in performance.

is my conception wrong? if wrong can anyone clear that? also if anyone has tied this please do let me know.

Thanks,
Sid

User avatar
Kentico Developer
Kentico Developer
kentico_martind - 11/10/2009 4:41:57 AM
   
RE:Using Indexed View for performance
Hi Sid,

Please note there are indexes already defined on the tables and these indexes takes effect in views composed from these tables as well.

Best Regards,

Martin Dobsicek

User avatar
Member
Member
ASI-fujibikes - 11/15/2009 1:40:33 AM
   
RE:Using Indexed View for performance
Thank you Martin

Regards,
Sid