Hi,

I have a list of members I need to filter by name and apply pagination to.

I get all the members as follows:

List<int> memberIds = null;
UmbracoDatabase db = ApplicationContext.Current.DatabaseContext.Database;
memberIds = db.Query<int>("SELECT id FROM umbracoNode WHERE nodeObjectType='39EB0F98-B348-42A1-8662-E7EB18487560'").ToList();

After that I get the full Ipublished member.

    List<ExtendedMember> extendedMembers = new List<ExtendedMember>();

foreach (int memberId in memberIds)
{
        IPublishedContent currentPublishedMember = memberShipHelper.GetById(memberId);
        ExtendedMember extendedMember = new ExtendedMember(currentPublishedMember);
        //MemberEmail is alleen Dynamisch beschikbaar
        extendedMember.Email = (extendedMember.GetProperty("Email").Value != null ? extendedMember.GetProperty("Email").Value.ToString() : "");
                    extendedMembers.Add(extendedMember);
        }

The problem is that this takes way to long (about 8 sec) and I get a lot of stuff I don't need.

I need the member:

• Firstname
• Prefix
• Last name
• Phonenumber
• profile image

Seems a bit silly to get the full IPublishedMember for this.

What would be the best approach to make this perform better?

• I could cache the result, but when and how and how about filtering?
• I could make a custom database table and fill it with the content I need and query the database with the correct filters?

Thanks again,

Frans