Portal Engine Questions on portal engine and web parts.
Version 6.x > Portal Engine > Select * from Joined Versions view causing Time outs View modes: 
User avatar
Member
Member
cmsteam-motivetechnology - 6/5/2013 8:04:07 AM
   
Select * from Joined Versions view causing Time outs
Hi, i have just imported a v5 site into a new v6 installation with the latest (.58) hotfix applied. The import ran fine and the site works as expected however it is painfully slow in the CMSDesk and regularly times outs.

I ran SQL Profiler and found the first reason it was so slow was a query been executed over and over until the app timed out.
select * from CMS_Site where SiteId = 3

As the site was an import of a multi-site install the SiteId was not the same on he new site so i had to remove the site, set force the auto increment back to 2 then re import.

That solved my first issue however the CMSDesk still ran slow so i went back to SQL profiler and found a query (below) was been executed which on a small site would be fine however the site has over 4,200 pages so the query takes 27 seconds.
SELECT  * FROM View_CMS_Tree_Joined_Versions WHERE (NodeSiteID = 3) AND (DocumentCulture = N'en-GB') 

Is this a Kentico v6 issue or content related issue (caused by inefficient use of a web part)?

Thanks, Anthony.

User avatar
Kentico Customer Success
Kentico Customer Success
kentico_martind2 - 6/7/2013 8:37:53 AM
   
RE:Select * from Joined Versions view causing Time outs
Hello Anthony,

Could you please tell me which .NET version are you running on? And what is the type of application pool? Have you turned off the debug mode in web.config file?

You can also take a look at our Performance Report ... there shouldn't be any problem with running up to a 100 000 documents.

Best regards,
Martin Danko