Thank You Sebastian, I was trying t run your scripts through SQL > HOST. But some scripts are not running and giving errors.

for an example these two scripts.

1) CREATE NONCLUSTERED INDEX IX_{objectQualifier}UserPortals_VanityUrl ON {databaseOwner}[{objectQualifier}UserPortals]
(VanityUrl)










2) CREATE FUNCTION {databaseOwner}[{objectQualifier}FitsExtendedPropertyPermission](
@viewingUserId int,
@viewedUserID int,
@extendedPermissions nvarchar(2000)) RETURNS bit
AS
BEGIN
DECLARE @rolesStr nVarChar(2000) = ''
DECLARE @reltnStr nVarChar(2000) = ''
DECLARE @gStartPos int
DECLARE @rStartPos int
DECLARE @recCount int = 0
DECLARE @SQL int
If (@viewedUserID > 0 and Len(IsNull(@extendedPermissions,'')) > 2) BEGIN
SET @gStartPos = CHARINDEX('G:',@extendedPermissions) + 2
SET @rStartPos = CHARINDEX('R:',@extendedPermissions) + 2
if @gStartPos > @rStartPos BEGIN
SET @rolesStr = SUBSTRING(@extendedPermissions, @gStartPos, Len(@extendedPermissions) - @gStartPos)
if @rStartPos > 0 SET @reltnStr = SUBSTRING(@extendedPermissions, @rStartPos, @gStartPos - @rStartPos - 1)
END
If @gStartPos < @rStartPos BEGIN
SET @reltnStr = SUBSTRING(@extendedPermissions, @rStartPos, Len(@extendedPermissions) - @rStartPos)
if @gStartPos > 0 SET @rolesStr = SUBSTRING(@extendedPermissions, @gStartPos, @rStartPos - @gStartPos - 1)
END
If @rolesStr <> '' BEGIN
SET @rolesStr = ',' + SUBSTRING(@rolesStr,1, Len(@rolesStr) - CASE WHEN RIGHT(@RolesStr,1) = ';' THEN 1 ELSE 0 END)
SELECT @recCount = COUNT(1) FROM {databaseOwner}[{objectQualifier}UserRoles] WHERE UserID = @viewingUserId AND @rolesStr LIKE '%,' + Convert(nvarchar(10),RoleId) + ',%'
END
If @recCount = 0 AND @reltnStr <> '' BEGIN
SET @reltnStr = ',' + SUBSTRING(@reltnStr,1, Len(@reltnStr) - CASE WHEN RIGHT(@reltnStr,1) = ';' THEN 1 ELSE 0 END)
SELECT @recCount = COUNT(1) FROM {databaseOwner}[{objectQualifier}vw_RelatedUsers] WHERE UserID = @viewingUserId AND relatedUserID = @viewedUserId AND @reltnStr LIKE '%,' + Convert(nvarchar(10),RelationShipID) + ',%' AND Status = 2
END
END
RETURN CASE WHEN IsNull(@RecCount, 0) > 0 THEN 1 ELSE 0 END
END





So I revert back my database to the old one again.

Please can you confirm if this SQL scripts are running on DNN 7.0.6 version as well? (upgraded from DNN 5.X time to time)

I have to remove the "GO" command at the end of each sqls and if I run it with that, giving errors. not sure why.

If you can give us a final SQL script file without errors, that would be great.

However I believe it would good if you can improve the DNN in the next release with allowing to have more number of folders in a DNN site without performance issue.

Appreciate yours supporting and advising.

The reason is to be with DNN 7.0.6 is, once I upgraded to DNN 7.1, the site/module settings were not loading and any popup were not loading. So I revert back to the older version DNN 7.0.6.

Anyway I am going to try again with DNN 7.1.1 version and then will try with the script you sent me.

Between the following is the reply from my hosting provider. Please let me know if you have any idea regarding this. Not sure whether they are correct. Thanks a lot for your great support.

"The application pool is recycling because the Worker Process keeps hitting it's Private Memory Bytes cap.
Your cap was apparently already moved up to 700000KB. I moved it up once more to 850000KB.
However, that has to be an issue with your code - some part of your application or plugin is causing a memory leak. "