Visual Builder

Get Involved. Join the Conversation.

Topic

    BHARAT RAMPALLY
    Performance on LOV's using external DB call...
    Topic posted June 21, 2018 by BHARAT RAMPALLYGreen Ribbon: 100+ Points, last edited June 21, 2018, tagged Database, REST, SaaS Integration, Web 
    60 Views, 2 Comments
    Title:
    Performance on LOV's using external DB call (VBCS)
    Summary:
    Call DB to populate list of values
    Content:

    We are trying to populate list of value for the PO field from the DB, but we are having performance issue and the list is not loading due to the data volume, how do we resolve this issue, is there any other way to call the OIC DB?

     

     

    Comment

     

    • Shay Shmeltzer

      How big is the list?

      Where is it stored?

      How about defining a variable (array) that host the list at the app or flow scope to eliminate constant fetch?

    • BHARAT RAMPALLY

      We are trying to pull the column list  from erp, close to 6k records, we are trying to load the data initially into db and then use ORDS.