Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Sundance 12 posts 52 karma points
    May 31, 2013 @ 23:07
    Sundance
    0

    Member ProfileBase property Limit

    Is there a limit or a point where performance starts to take a hit, with having too many member properties/values. I'm using the asp.net ProfileBase and currently have 32 properties, and it very well may turn into about 100+ by the time I'm done. So I wanted to just make sure that I woudln't run into issues down the road this way.

  • jeffreypriebe 4 posts 29 karma points
    Aug 01, 2013 @ 06:08
    jeffreypriebe
    0

    There is definitely a limit where you begin to run into problems. Many things in the Umbraco back-office will get really slow once you have a lot of properties - you want to keep a limit on them.

    We did a website some time ago, that has 497 properties on one of the member types. I recall that there was a hard limit where Umbraco failed entirely but I don't recall exactly what that number was (not much higher than what we have, so probably 500?).

    Mostly this isn't a major issue, but loading the member type or members of that type are slow operations. 100-150 properties would probably work but I would definitely think about storing things differently if you are going any higher. I wouldn't do the 497 above again if re-doing that site today.

    Far more of a concern is that Members aren't cached in Umbraco the same way that documents are. So working with members with a lot of properties can get slow. Accessing members via Examine can be a solution to get at members quickly, but just bear in mind that doing "new Member(id)" on a Member isn't coming out of a cache so a lot of members with a lot properties is going to be a non-trivial activity. But that depends on what you're going to do with the data.

    Note: this was on Umbraco 4.5.2 so hopefully things have improved. But this is the sort of thing I wouldn't expect to have been looked at much in the interleaving versions.

Please Sign in or register to post replies

Write your reply to:

Draft