We're running a large Umbraco site for about 2 months now, we have a UAT environment with a few members and a live environment with 60000+ members.
The UAT environment runs fast and can handle about 120 SBUs without slowing down, the live environment with all the members (the only thing that is different) will slow down at about 40 SBUs.
The version of Umbraco we're using is 4.7.2, all scripting is done in razor. Most of them are cached already.
Any ideas on how we can increase the db performance? Indexes on a few tables? ...
Not particularly sure about your issue -- but is the slowdown occuring in the backend? In the members section only or everywhere? Or is the slowdown using Razor to list members? There might be ways to optimize that.
Thanks for your reply. The slowdown is on the front, actually the whole site is not that fast. But it seems it has something to do with the members. The UAT with no members scores much better in performance tests.
Sounds very strange. You can try to get an idea of where the slowdown is by adding ?umbDebugShowTrace=1 to the end of your page's URL. If you have trace enabled, you'll see a log output at the bottom of the screen detailing each component and macro that loads, along with the time it took to load. This might help you pinpoint the problem. You could also try uGlimpse.
Post the results back here if you find something :)
Members in Umbraco causing website to go slow?
We're running a large Umbraco site for about 2 months now, we have a UAT environment with a few members and a live environment with 60000+ members.
The UAT environment runs fast and can handle about 120 SBUs without slowing down, the live environment with all the members (the only thing that is different) will slow down at about 40 SBUs.
The version of Umbraco we're using is 4.7.2, all scripting is done in razor. Most of them are cached already.
Any ideas on how we can increase the db performance? Indexes on a few tables? ...
Regards,
Kevin
Hi Kevin,
Not particularly sure about your issue -- but is the slowdown occuring in the backend? In the members section only or everywhere? Or is the slowdown using Razor to list members? There might be ways to optimize that.
-Tom
Hi Tom,
Thanks for your reply. The slowdown is on the front, actually the whole site is not that fast. But it seems it has something to do with the members. The UAT with no members scores much better in performance tests.
Regards,
Kevin
Sounds very strange. You can try to get an idea of where the slowdown is by adding ?umbDebugShowTrace=1 to the end of your page's URL. If you have trace enabled, you'll see a log output at the bottom of the screen detailing each component and macro that loads, along with the time it took to load. This might help you pinpoint the problem. You could also try uGlimpse.
Post the results back here if you find something :)
is working on a reply...