Dashboard / login slowness

mcole_1967

Hello,

We are seeing performance issues when loading the dashboard page in ProGet. Specifically loading the "DashboardFeeds" view in the database is taking anywhere from 15 to 30+ seconds to run. Sometimes the application will timeout waiting for this to happen.

We have ProGet configured with domain authentication and are only giving permissions (including read) to specific users / groups. To minimize what information unauthenticated users see we have the advanced option "Web.HideHomePageFromAnonymousUser" enabled. Despite this, hitting the root of the application without credentials seems to build the dashboard in the background before redirecting to /log-in. If multiple people (authenticated or not) try and load the dashboard at the same time then the likelihood of the application timing out requests increases.

Is there any way to prevent the application from doing the expensive dashboard build operation until after the credentials have been checked?

Would upgrading to the latest version likely help the performance at all? (Noticing a closed issue around SQL locking in the release notes..) .. or do we need likely need to throw more resources at the database server to make the page render in a reasonable amount of time?

Thanks,

Martin

Product: ProGet
Version: 5.1.8

ben

Hello Martin,

I've filed PG-1422 to stop ProGet from checking whether anonymous users have any feeds they can access. You may also want to check in SSMS whether any of the indexes need to be rebuilt or reorganized.