Hii everyone. dont know if this is the right place for this question, but i did'nt find other relevant forum.
I have 2 sites running on my iis , one is umbraco 4.7.2 , one is umbraco 6.
When checking the sql profiler i see that both of them invoke aome queires every one minute.
The first one - ( umbraco 4.7 ) invoke this queries every one minute : 1 - exec sp_executesql N'select distinct nodeId, level, sortOrder from cmsDocument inner join umbracoNode on umbracoNode.id = cmsDocument.nodeId where newest = 1 and not releaseDate is null and releaseDate <= @today order by [level], sortOrder',N'@today datetime',@today='2013-02-25 16:52:55.643' ( by the current date ) 2 - exec sp_executesql N'select distinct nodeId from cmsDocument where newest = 1 and not expireDate is null and expireDate <= @today',N'@today datetime',@today='2013-02-25 16:53:55.670'. ( by the current date )
The second one - ( umbraco 6 ) invoke this queries every one minute : 1 - SELECT *
FROM [cmsDocument]
INNER JOIN [cmsContentVersion]
ON [cmsDocument].[versionId] = [cmsContentVersion].[VersionId]
INNER JOIN [cmsContent]
ON [cmsContentVersion].[ContentId] = [cmsContent].[nodeId]
INNER JOIN [umbracoNode]
ON [cmsContent].[nodeId] = [umbracoNode].[id]
WHERE ([umbracoNode].[nodeObjectType] = 'c66ba18e-eaf3-4cff-8a22-41b16d66a972')
AND ([cmsDocument].[published] = 'False' AND [cmsDocument].[releaseDate] <= '02/25/2013 16:55:46')
2 - SELECT *
FROM [cmsDocument]
INNER JOIN [cmsContentVersion]
ON [cmsDocument].[versionId] = [cmsContentVersion].[VersionId]
INNER JOIN [cmsContent]
ON [cmsContentVersion].[ContentId] = [cmsContent].[nodeId]
INNER JOIN [umbracoNode]
ON [cmsContent].[nodeId] = [umbracoNode].[id]
WHERE ([umbracoNode].[nodeObjectType] = 'c66ba18e-eaf3-4cff-8a22-41b16d66a972')
AND ([cmsDocument].[published] = 'False' AND [cmsDocument].[releaseDate] <= '02/25/2013 16:55:46')
Understanding sql queries
Hii everyone. dont know if this is the right place for this question, but i did'nt find other relevant forum.
I have 2 sites running on my iis , one is umbraco 4.7.2 , one is umbraco 6.
When checking the sql profiler i see that both of them invoke aome queires every one minute.
The first one - ( umbraco 4.7 ) invoke this queries every one minute :
1 - exec sp_executesql N'select distinct nodeId, level, sortOrder from cmsDocument inner join umbracoNode on umbracoNode.id = cmsDocument.nodeId where newest = 1 and not releaseDate is null and releaseDate <= @today order by [level], sortOrder',N'@today datetime',@today='2013-02-25 16:52:55.643' ( by the current date )
2 - exec sp_executesql N'select distinct nodeId from cmsDocument where newest = 1 and not expireDate is null and expireDate <= @today',N'@today datetime',@today='2013-02-25 16:53:55.670'. ( by the current date )
The second one - ( umbraco 6 ) invoke this queries every one minute :
1 - SELECT *
FROM [cmsDocument]
INNER JOIN [cmsContentVersion]
ON [cmsDocument].[versionId] = [cmsContentVersion].[VersionId]
INNER JOIN [cmsContent]
ON [cmsContentVersion].[ContentId] = [cmsContent].[nodeId]
INNER JOIN [umbracoNode]
ON [cmsContent].[nodeId] = [umbracoNode].[id]
WHERE ([umbracoNode].[nodeObjectType] = 'c66ba18e-eaf3-4cff-8a22-41b16d66a972')
AND ([cmsDocument].[published] = 'False' AND [cmsDocument].[releaseDate] <= '02/25/2013 16:55:46')
2 - SELECT *
FROM [cmsDocument]
INNER JOIN [cmsContentVersion]
ON [cmsDocument].[versionId] = [cmsContentVersion].[VersionId]
INNER JOIN [cmsContent]
ON [cmsContentVersion].[ContentId] = [cmsContent].[nodeId]
INNER JOIN [umbracoNode]
ON [cmsContent].[nodeId] = [umbracoNode].[id]
WHERE ([umbracoNode].[nodeObjectType] = 'c66ba18e-eaf3-4cff-8a22-41b16d66a972')
AND ([cmsDocument].[published] = 'False' AND [cmsDocument].[releaseDate] <= '02/25/2013 16:55:46')
Is that ok? Why is that happend?
Thanks in advance.
Cheers.
is working on a reply...