Performance issues when using members with member properties
I'm running a site (umbraco 6) which contains about 400 members. These members have around 50 custom textstring properties each (and growing).
However, when I'm logged in as one of the members every call to the website takes around 2 seconds to load. I looked at the umbShowDebugTrace output to see if any macro's are the bottleneck, but the entire page until pagerender takes about 0.1 second.
So I've started looking in the SQL Profiler, and what seems is that when a Member is logged in all properties of the member get updated for each call (over 50 UPDATE queries). Even on a simple GET call when using nothing special.
I don't do any saving of the members in the macros.
Performance issues when using members with member properties
I'm running a site (umbraco 6) which contains about 400 members. These members have around 50 custom textstring properties each (and growing).
However, when I'm logged in as one of the members every call to the website takes around 2 seconds to load. I looked at the umbShowDebugTrace output to see if any macro's are the bottleneck, but the entire page until pagerender takes about 0.1 second.
So I've started looking in the SQL Profiler, and what seems is that when a Member is logged in all properties of the member get updated for each call (over 50 UPDATE queries). Even on a simple GET call when using nothing special.
I don't do any saving of the members in the macros.
I tried using
<profile enabled="true" automaticSaveEnabled="false">in the web.config to disable automatic saving of the profile fields, but it doesn't help.
Anybody else seen this strange behavoir? Why is this neccessary, and more importantly, how can I disable it?
is working on a reply...