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.