Hi Admin,

When multiple admin start adding content, many times application shows 'Timeout exception'. I debug this and found the mostly this query timeout

SELECT this_.NodeVersionId as y0_ FROM dbo.NodeVersionStatusHistory this_ inner join dbo.NodeVersion outerversi1_ on this_.NodeVersionId=outerversi1_.Id WHERE this_.Date in (SELECT max(this_0_.Date) as y0_ FROM dbo.NodeVersionStatusHistory this_0_ inner join dbo.NodeVersion innerversi1_ on this_0_.NodeVersionId=innerversi1_.Id WHERE innerversi1_.NodeId = outerversi1_.NodeId) ORDER BY this_.Date desc

when i ran this query in sql management studio, it ran in less than a second. Following is the piece of code that casue this error (inside umbraco).

Line 206: if (limitToLatestRevision) getVersionIds = getVersionIds.WithSubquery.WhereProperty(() => innerHistory.Date).In(subQueryOfHistory);
Line 207:
Line 208: var versionIds = getVersionIds
Line 209: .Select(x => x.NodeVersion.Id)
Line 210: .List<Guid>()

Please help me.

Balesh Kumar