Is there a way to reduce the amount of time between dependent field refreshes?

Matt_Simon
Matt_Simon
in AppWorks #1

We are just getting started with developing flows in version 9.2 and what I am noticing is that where I have drop down fields where the list options are dynamically generated from a business object or SQL query that is dependent on another field on the form, that the amount of time it takes to refresh the list is quite long. This makes for an awkward user experience since sometimes the refresh takes longer than it does for the user to move to the dropdown and so they select it and then see the list refresh.

 

Is there a configuration setting somewhere that can be changed to make the dependent fields refresh faster?

 

-Matt

Tagged:

Comments

  • Robert Vignerot
    Robert Vignerot
    #2

    I'm not aware of a "Go Faster" button.  Make sure you try to restrict the number of fields marked as "Is Dependant" to only the one that you need to re-fresh and try to ensure the queries/web services called have as little latency as possible.

  • Lindsay_Iain
    Lindsay_Iain
    #3

    Also, if you are using a business object to populate the dropdown be aware that the entire query will be executed which may return data for columns you don't need.

     

    iain

  • Tom Waskow
    Tom Waskow
    #4

    We have seen poor performance with dynamically generated drop-downs only in two situations.

     

    First, if the query is returning a very large number of items. This can definitely make the form slow. It is a better user experience if you can find a way to reduce the number of items returned (cascading drop-downs, add a filter to the query, etc.)

     

    The other situation is when the query itself is slow. If you are using adhoc SQL in your business object, you might try creating a stored procedure instead to take advantage of the optimization that a database can provide.

Categories

image
OpenText CE Products
AppWorks
Gateway & Platform