問題文
A recruiting firm added a cross-object formula field on the application record that derives a score from the related job posting. The recruiters now filter and sort a list view of 400,000 applications by that score, and the list view takes a long time to open. Which explanation fits, and what follows from it?
選択肢
- The formula field is fine as it is, and the delay comes from the list view showing too many columns; removing some of those columns will restore the speed of the list view without touching the field itself.
- The formula should be converted into a roll-up summary field on the application, because a roll-up summary stores its value and would therefore give the same number without the read-time cost and without any additional automation to maintain.
- The formula was saved with an old API version, so it recalculates far more often than a newer one would do on the same record each time that it is read and shown.
- A formula field stores no value and is worked out every time the record is read, so a value that large numbers of users filter and sort by is better held in a stored field that automation maintains.