Forum Discussion

rmichaelsmi's avatar
rmichaelsmi
New Contributor II
2 years ago

updating a lot of UD Text# fields is taking forever, what is a faster way?

What I have found is that using the BRApi.Finance.Members.GetMemberInfo or Metadata.GetMember calls with True for includeProperties or even the first call to BRApi.Finance.UD.Text(...) all incur an a...
Admin
Extenders
Finance
RobbSalzmann's avatar
RobbSalzmann
Valued Contributor II
2 years ago

Is your requirement to show a grid view with 27,000 members? 
What is your requirement for looping over 27,000 projects?

I would consider finding a way to do this with SQL and Data Management.

  • rmichaelsmi's avatar
    rmichaelsmi
    New Contributor II
    2 years ago

    See new EDITED context.  We pull the text field values from a sql table and are comparing to what is in OneStream and updating.  The text field values are from an external source.