Bug reports
Version 2.x > Bug reports > View_PageInfo - 1minute 40 second query time View modes: 
User avatar
sedonatek - 9/27/2007 4:25:25 AM
View_PageInfo - 1minute 40 second query time
We just upgraded a large site (over 9,000 documents) from 2.1d to 2.1e to 2.2 and then to 2.3 - when we upgraded to 2.3 we started experiencing 1 minute 40 second times on this query:
SELECT * FROM View_PageInfo 
WHERE ((NodeSiteID = 1)
AND ((NodeAliasPath = N'/'
AND (DocumentCulture = N'en-US'))
OR (DocumentUrlPath = N'/')))
ORDER BY DocumentUrlPath ASC

in 2.2 this query time was 0.4 seconds... do you have a solution for this?

User avatar
kentico_vitaja - 10/2/2007 3:30:18 PM
RE:View_PageInfo - 1minute 40 second query time

we are sorry for this inconvenience - it is known performance bug and we are currently working on it. We will release fix for it ASAP, most likely this week.

Best regards,
Vita Janecek