Hi there, we have an issue with our Umbraco site performing some 1547 queries that don't appear to be necessary, which in turn is causing a 3 second delay on the page load.

We have tested this form in Umbraco 7.3 up to 7.5.4 all with Forms versions 4.1 to 4.3.3 and have not had any luck as yet.

We have a simple page template setup which in turn load a marginally complex form consisting of 4 pages. When not logged in the page loads in 30ms however when logged in it is taking 3 seconds.

The queries that are being executed are identical - exporting an SQL Profiler dump out to excel and removing duplicates removed this number (1547). This query was:

exec sp_executesql N'SELECT *
FROM [cmsMember]
INNER JOIN [cmsContentVersion]
ON [cmsContentVersion].[ContentId] = [cmsMember].[nodeId]
INNER JOIN [cmsContent]
ON [cmsContentVersion].[ContentId] = [cmsContent].[nodeId]
INNER JOIN [cmsContentType]
ON [cmsContentType].[nodeId] = [cmsContent].[contentType]
INNER JOIN [umbracoNode]
ON [cmsContent].[nodeId] = [umbracoNode].[id]
WHERE (([umbracoNode].[nodeObjectType] = @0))
AND (upper([cmsMember].[LoginName]) = upper(@1))
ORDER BY ([umbracoNode].[sortOrder])',N'@0 nvarchar(40),@1 nvarchar(4000)',@0=N'39eb0f98-b348-42a1-8662-e7eb18487560',@1=N'[email protected]'

Mini-profiler is stating all this time is inside InsertUmbracoForm.cshtml however Form.cshtml and Script.cshtml have been untouched and contain no member data.

Trace and Debug are both false in the web.config too.

Anybody have any advise on what we can do or test from here?

Thank you for your help, Warren