For Select component/On change event, which method is best?

UI Builder
1

I have always believed minimizing DB IOs was the best method to maintain best performance in my apps. When I try to FIND the user-selected value in the options list, I get an error message “Maximum request per minute limit has been reached for the app. Current limit is 500 requests per minute”

image
image708×187 16.7 KB

The alternative is to do another DBIO to retrieve the user-selected item from the DB.
image
image310×194 10.1 KB

Which is best?

2

Hi @Richard_Munger,

The first option with FIND doesn’t make database queries, so it should be better if we want to reduce the number of requests. It’s possible that dependent queries related to changing variables are being triggered elsewhere. Open the browser’s network activity and check what requests are being made when the onChangeEvent is triggered in both options.

Regards,
Sergey