Sign in Register
Copied to clipboard

Flag this post as spam?

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


  • Josh Olson 79 posts 207 karma points
    Nov 17, 2014 @ 16:21
    Josh Olson
    0

    MemberService GetAllMembers is *very* slow when members have lots of custom properties

    Hi all,

    I am facing an issue where I have lots of custom properties for my members (I didn't count but well over 100) and performance is painfully slow (depending on site usage, between one and five minutes!) when using GetAllMembers() or GetMembersByGroup().

    I assume this is because GetAllMembers() is going out to the db and getting everything about the member including all custom properties. Is there a way to get all members without also getting all the custom properties (maybe just the built in properties)?

    For clarity, I need to get all the members in a specific group and then perform some sorting/filtering based on a small subset of the custom properties. If anyone has hints on a better way to do things I am all ears!

    Cheers!

    Copy Link
  • Alex Skrypnyk 6175 posts 24186 karma points MVP 8x admin c-trib
    Mar 06, 2020 @ 13:34
    Alex Skrypnyk
    0

    Hi Josh

    We struggle with a similar issue, can you help - how to improve the performance of GetAllMembers() or GetMembersByGroup() methods?

    Thanks,

    Alex

    Copy Link
Please Sign in or register to post replies

Write your reply to:

Draft