Select the search type
  • Site
  • Web
Search
You are here:  Support/Forums
Support

Bring2mind Forums

Load times very slow
Last Post 11/26/2015 9:48 PM by Peter Donker. 2 Replies.
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
Roger Goodwin
New Member
New Member
Posts:7


--
06/23/2015 7:58 PM
I have an issue where a folder containing about 60 sub folders is taking about 12 seconds to load.
I have searched for solutions and found a couple which involve creating indexes however none of these have made a difference.

I have set the site to use heavy cache but nothing seems to make a difference. My concern is that over the coming 6 months this folder is going to double in size.

Is there any way to speed up the load time of this folder?
DrewSK
New Member
New Member
Posts:15


--
06/24/2015 3:28 PM
Roger,

I'm one of the people who had horrendous load times on DMX until I did some performance tuning through indexes on the UserRoles table in DNN/SQL. The reason why the site cach-ing makes little difference is the performance cost is in the database. My DNN instance is set to light cache, and after changes to the datastructure it is working well.

Depending on your comfort level with SQL, we can check into these 2 things:
What is the clustered index on your UserRoles table at this point?
Let's run a SQL Profiler trace while that page loads and see how long the query takes. We're specifically looking for the procedure 'DMX_GetEntryByTitleInCollection' as it can be a real bear.

This is the script I keep saved as a record of the most significant change I made:
IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[UserRoles]') AND name = N'PK_UserRoles')
ALTER TABLE [dbo].[UserRoles] DROP CONSTRAINT [PK_UserRoles]
GO

/****** Object:  Index [PK_UserRoles]    Script Date: 05/24/2013 08:30:54 ******/
ALTER TABLE [dbo].[UserRoles] ADD  CONSTRAINT [PK_UserRoles] PRIMARY KEY NONCLUSTERED 
(
	[UserRoleID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO


CREATE CLUSTERED INDEX DMX_IDROLE
ON dbo.UserRoles (UserID, RoleID)  


Drew
Peter Donker
Veteran Member
Veteran Member
Posts:4536


--
11/26/2015 9:48 PM
Drew is on the right track here. The overall performance of DMX is related to the product of:

Nr files and folders, nr of roles, and nr of users. UserRoles sit right in the middle of this. If you have a large set of users paired with a large set of roles, this can become a burden for SQL server as it tries to work out who has access to what. Since DMX can't make changes to core tables, it is best to do this yourself as Drew illustrated.

Peter
You are not authorized to post a reply.