+1-888-365-2779
Try Now
More in this section

Forums / Bugs & Issues / Slow Loading User Admin Page - SF 3.7 .NET 4.0

Slow Loading User Admin Page - SF 3.7 .NET 4.0

11 posts, 0 answered
  1. Jon Kramme
    Jon Kramme avatar
    15 posts
    Registered:
    20 Dec 2009
    05 May 2011
    Link to this post
    When we were running SF 3.6, the Sitefinity user admin page was very slow loading - usually about 2 minutes - for about 5,000 site users.  At the time (see prior posting from "Steve" on this topic), we were advised to upgrade to SF 3.7 SP3, which would correct the issue.

    Last week, we upgraded to SF 3.7 - specifically the version that runs with .NET Framework 4.0 (SP3 or SP4, I think?).  The site in general seems to perform very well, but that user admin page is still just as slow as before.

    Why would this be?  Could there be some kind of setting in web.config?

    Thank you!
  2. Ivan Dimitrov
    Ivan Dimitrov avatar
    16072 posts
    Registered:
    25 Nov 2016
    06 May 2011
    Link to this post
    Hi Jon,

    When a user gets logged I suppose that it goes to your dashboard. Can you try disabling all dashboard items and see if there will be any difference?

    Kind regards,
    Ivan Dimitrov
    the Telerik team
    Do you want to have your say in the Sitefinity development roadmap? Do you want to know when a feature you requested is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
  3. Jon Kramme
    Jon Kramme avatar
    15 posts
    Registered:
    20 Dec 2009
    26 May 2011
    Link to this post
    Hi Ivan,

    I'm just now getting back to this issue.  You're suggestion did not make any difference.  The Administration > Users page continues to take approximately 2 minutes or more to load for about 5,000 users.  All other administration pages, such as Dashboard, Pages, etc., load at a good speed (just a few seconds).

    Do you have any other ideas?  In addition to all of the other admin pages loading just fine, all of our site's pages also load at a very good speed.  It is only the Administration > Users page that is so slow.

    Thank you!
  4. Ivan Dimitrov
    Ivan Dimitrov avatar
    16072 posts
    Registered:
    25 Nov 2016
    26 May 2011
    Link to this post
    Hello Jon ,

    We made optimizations related to the way that users are loaded in Sitefinity SP3 and SP4. Please make sure that you use SP4. Also you could experience this issue the first time you load users sections, because all users are loaded into the memory from the membership provider. Subsequent request should be faster.

    All the best,
    Ivan Dimitrov
    the Telerik team
    Do you want to have your say in the Sitefinity development roadmap? Do you want to know when a feature you requested is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
  5. Jon Kramme
    Jon Kramme avatar
    15 posts
    Registered:
    20 Dec 2009
    01 Jun 2011
    Link to this post
    Hi Ivan,

    I confirmed that we are using Sitefinity 3.7 SP4, and it is running in the .NET 4.0 framework.  The problem has now escalated to where the users are getting a timeout error when trying to load the page, thus they cannot manage (add, edit, delete) users.

    5,000 users isn't an excessive number to load.  It ought to handle that with little effort.  When the page would load, if we filtered the list down, the filtered results returned quickly.  Unfortunately, if we can't get the page to load in the first place, there's no chance to filter the list down.

    We intend to begin planning for an upgrade to 4.1 later this year, but we need to find an immediate solution to this problem now since it causing a work stopage.

    What else can be done to correct this?  Do I need to open a support ticket instead of working through the forum?

    Thanks!
  6. Jon Kramme
    Jon Kramme avatar
    15 posts
    Registered:
    20 Dec 2009
    07 Jun 2011
    Link to this post
    We're still experiencing slow load times (about 2 minutes) on the user admin page, for about 5,000 users.  See previous posting for more details.  What next steps can be tried to resolve the issue?  Thanks!
  7. Ivan Dimitrov
    Ivan Dimitrov avatar
    16072 posts
    Registered:
    25 Nov 2016
    08 Jun 2011
    Link to this post
    Hello Jon ,

    Is this the standard provider - TelerikMembershipProvider , Active Directory or a custom provider? If you use Active Directory all users are loaded into the memory and this might be the problem and in this case you can use some of the filter parameters.

    Best wishes,
    Ivan Dimitrov
    the Telerik team
    Do you want to have your say in the Sitefinity development roadmap? Do you want to know when a feature you requested is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
  8. Jon Kramme
    Jon Kramme avatar
    15 posts
    Registered:
    20 Dec 2009
    08 Jun 2011
    Link to this post
    Hi Ivan,

    We're using the standard TelerikMembershipProvider.  Is there a way to default the page to load only a subset of users, such as only those belonging to a certain role?  After the page finally loads, when I click on the links to view members in a certain role, the response time is good as long as the number of users in the role is roughly below 500.  Likewise, searching runs at a good speed as long as the number of results is relatively small.  It seems to disproportionately slow down when the number of elements in the grid exceeds 500.  And I'm not sure if this is possibly related, but we're running SSL on the site.

    Here's a full overview of our configuration...

    Web server: IIS 6
    ASP.NET Framework: 4.0
    Sitefinity version: 3.7 SP4 (TelerikMembershipProvider)
    Database server:  MS SQL Server 2005

    The only Sitefinity page we have modified is the login screen.  All other Sitefinity admin screens are as-provided by Telerik.  We use the Sitefinity API to create Sitefinity users and assign them to roles.  In doing that, we only provide the minimum data needed to create a user, such as user name, password and email address.  We have not modified the database in any way.  We are using the version of the Telerik Rad Controls that ships with Sitefinity 3.7 SP4.

    Thank you!

    Jon
  9. Ivan Dimitrov
    Ivan Dimitrov avatar
    16072 posts
    Registered:
    25 Nov 2016
    13 Jun 2011
    Link to this post
    Hello Jon,

    I created 5000 users and there is no performance impact. You can take a look at attached video.

    Greetings,
    Ivan Dimitrov
    the Telerik team
    Do you want to have your say in the Sitefinity development roadmap? Do you want to know when a feature you requested is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
  10. Jon Kramme
    Jon Kramme avatar
    15 posts
    Registered:
    20 Dec 2009
    15 Jun 2011
    Link to this post
    I'll watch the video, but I'm not sure where this leaves me on what to try next.  We have a system that in all other respects runs at a very good speed, so causes like inadequate hardware don't make sense.

    It's just that user admin page that bogs down.  Do the SQL tables have any indexing applied to them?  If not, perhaps a good indexing strategy could boost the query, assuming the bottleneck is in the SQL layer and not up in the API.  Does the RadGrid fetch only the rows needed to display page 1, or is it fetching all of the rows?

    Jon
  11. Ivan Dimitrov
    Ivan Dimitrov avatar
    16072 posts
    Registered:
    25 Nov 2016
    16 Jun 2011
    Link to this post
    Hi Jon ,

    The way that the queries are passed to the database is handled by the datalayer and we do not apply indexing explicitly. The backend where users are listed uses ASP.NET GridView control. We get only the first 20 users when bound the GridView (this is the first page only, when you click on the second page we get the next 20 users.) .

    Kind regards,
    Ivan Dimitrov
    the Telerik team
    Do you want to have your say in the Sitefinity development roadmap? Do you want to know when a feature you requested is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
Register for webinar
11 posts, 0 answered