• Published
  • Record Limits by Feature



    Record Limits by Feature

    Salesforce allows Visualforce pages (ManageFrameworks, ManageIndicators, SetTargets, AddResults, ManageDisbursements) to have a maximum view state size of 170KB.

    Columns marked with LTA LOAD TIME don't represent the limit on the number of LongTextArea fields that can be added to that page, but rather the response time to load the page if one/ multiple LongTextArea fields are added to the display table field sets.

    Feature

    Record Limit

    Processing / Loading Time

    ManageIndicators VisualForce

    10 Project Indicators and 680 Catalog Indicators when ampi__Type_of_Results__c = Aggregated, Calculated, and Input.

    65 Project Indicators and 740 Catalog Indicators when ampi__Type_of_Results = Input only*.

     

    *This data load is only affected by Indicator records where Include_In_Catalog_c = TRUE. This limit applies when all the fields of Indicator and Project Indicator records are fully populated. Additional custom fields added to the fieldsets referenced on the ManageIndicators page may decrease the Record Limit.

    1-2 mins

    manageIndicators LWC

    800 Project Indicators, 1200 Catalog Indicators, and 200 Deactivated Indicators

    1 min

    manageIndicators with Calculated Indicators LWC

    420 Project indicators (all disaggregated by 7 custom values out of which:
    320 are Input Indicators
    100 are Calculated Indicators with 40 indicators that use aggregated indicators as source indicators.

    2-3 mins

    manageIndicators with Aggregated Indicators LWC

    238 Aggregated Project Indicators

    2-3 mins

    ManageFramework

    1,000 Project Objectives

    1-2 mins

    SetTargets VisualForce

    300 Results (per Reporting Period & Geographic Area combination within a Project)

    1-2 mins

    AddResults VisualForce

    SetTargets / AddResults

    VisualForce

    STAR pages support following combinations of PGAs (PIGAs), RPs (PIRPs), Disaggregation Groups (DPIs) and PIs:

    50 PIs when Project has 200 RP (2000 PIRP) and 210 PGA (1750 PIGA)

    220 PI (220 DPI), 60 RP (600 PIGA), 30 PGA (250 PIGA)**

     

    **Factors contributing to load limits are the number of records (PI, RP, PGA, DPI, Results, etc), amount of data in fields (e.g. LongTextArea fields containing a lot of text contribute significantly view state size).

    <1 min

    SetTargets / AddResults
    LTA LOAD TIME

    60 Project Indicators with 16 Reporting Periods, 9 Geographic Areas with: 

    1. 4 LongTextArea fields in ST/ AR Info popover (Objective, Guideline, TA, Data Source)

    2. 1 LongTextArea field in ST/ AR Info popover (Guidelines)


    1. Multiple LongTextArea fields

      1. Page Load Time: 10 Sec

      2. Changing RP/GA Load Time: 4 sec

    2. Single LongTextArea field

      1. Page Load Time: 8 Sec

      2. Changing RP/GA Load Time: 3 sec

    Set Targets LWC

    800 Result Records For example:

    • 100 Project Indicators that are that are all cross disaggregated by sex for 8 RPs.

    • 200 Project Indicators that are all disaggregated by a custom Disaggregation Group with 2 values for 2 RPs. 

    • 400 Project Indicators that are all disaggregated by a custom Disaggregation Group with 2 values for 1 RP.

    A maximum of 32 Reporting Periods per Target Frequency can be loaded on the page(e.g. 40 total Reporting Periods will work if 8 are annual and 32 are quarterly)

    If fewer Reporting Periods are displayed, more Project Indicators can be displayed. 

    1-3 mins

    Set Targets LWC
    LIBERTAS v1.35 onwards

    7680 result records. For example:

    • 60 Project Indicators that are all disaggregated by a custom Disaggregation Group with 4 values for 32 reporting periods

    1-3 mins

    Add Results LWC

    800 Result Records

    1-3 mins

    Add Results LWC

    Mira v1.37 onwards

     

    1600 result records

    • 400 Project Indicators that are all disaggregated by a custom Disaggregation Group with 4 values for 1 RP

    1-3 mins

    Set Targets LWC Upload Mira v1.37 onwards

    5250 result records

    • 50 disaggregated PIs that are all disaggregated by a custom Disaggregation Group with 7 values for 15 Reporting Periods

    1-3 mins

    Aggregated Indicators Visualforce

    390 Aggregated Indicators

    8-12 min

    Calculated Indicators VISUALFORCE

    390 Calculated Indicators 

    8-12 min

    Submissions

    250 Questions per Template

    25 Sections per Template

    N/A

    Radar charts

    8 Submissions per parent record (Recommended - limit is over 100)

    N/A

    Activities (AURA)

    300 Activities per Implementation Plan (Recommended - limit is 6,500)

    N/A

    Activities (LWC)

    50 Implementation Plans with 300 Activities each

    4500 Activities at once. This could be:

    • Multiple Implementation Plans with total 4500 Activites displayed simultaneously in the Activities table

    • Single Implementation Plan with total 4500 Activities displayed in the Activities table

    < 1 min

    Activities Excel Upload

    300 records with 20 fields including 1 LongTextArea field

    < 15 sec

    Activities Excel Download

    300 records with 20 fields including 1 LongTextArea field

    < 10 sec

    Disbursements

    1,000 Disbursements

    1-2 mins

    Budget Excel Upload

    2,000 Financials (with 12 columns)

    1,800 Financials (with 25 columns)

    1-2 mins

    Enhanced Budget Planning Excel

     

    • For 1 Reporting Period as Budget Planning Period: 635 Financials (with 25 attribute columns and 4 planning periodic columns)

    • For 12 Reporting Periods as Budget Planning Periods: 2800 Financials (with 25 attribute columns and 4 planning periodic columns)

    • For 1 Reporting Period as Budget Planning Period: 1600 Financials (with 25 attribute columns and 4 planning periodic columns)Nashira v1.38 onwards

    • For 12 Reporting Periods as Budget Planning Periods: 3000 Financials (with 25 attribute columns and 4 planning periodic columns) Nashira v1.38 onwards

    1-2 mins

    Enhanced Financial Reporting Excel

    600 Financials (with 25 attribute columns and 4 reporting periodic columns)

    720 Financials (with 25 attribute columns and 4 reporting periodic columns)Nashira v1.38 onwards

    1-2 mins

    IATI Reporting

    20 Projects with with the following child records (in total):

    • Reporting Period - 20

    • Organization Role - 20

    • Project Role - 20

    • Project Geographic Area - 60

    • Project IATI Sector - 20

    • Project IATI Policy - 20

    • Budget - 200

    • Transaction (Disbursement and Financial) - 11,000

    • Transaction Project IATI Sector - 1400 (for both Disbursement and Financial)

    • Project objective - 200

    • Project Indicator - 2000

    5-8 min