onAction() should accept a parameter as a field value

[rafig]

Hi

Thanks for the tip!
Is a valuelist really loaded fresh from DB each time when a form shows, or just only once at form.onShow/firstShow ?
When the first is true, I can imagine that it slows down a solution, while the second is totally fine, as then a valuelist is loaded only when it is needed.

I can't say for sure, but if anything might have changed in it, I guess Servoy may reload it.
Might be an idea to check the 'Performance' page of Admin clearing, it, then displaying your forms with Vls, then changing form, clearing perf. then checking again and seeing if it might be reloading??
(Otherwise, someone from Servoy might want to say).
I do know that for my client, it improved performance, YMMV.
You could test as well by creating 'static' copies of your current value lists as above, and then re-assigning them on your form (but keeping the original ones to assign back to if no speed gain)

[Bernd.N]

Thanks for the tip!
I tested it, and a second call of a form that has a specific table-related valuelist does not fire an additional SELECT on the DB.
However I noted that we use too much valuelists for large tables, as each of them certainly result in such a SELECT. We will refactor them to picklists that fire only in the moment when the user actually uses them.

I also saw this message in the console, seems to be new in the latest Servoy edition, and this adds to my feeling that valuelists are not the proper tool for large tables:
Valuelist vl_ps_employee_full_name fully loaded with 500 rows, more rows are discarded!!

I also did this performance test with http://localhost:8080/servoy-admin/performance on startup and got again a lot of valueable information where we can improve things.
That tool is really a great help.

[rafig]

Thanks for the tip!
I tested it, and a second call of a form that has a specific table-related valuelist does not fire an additional SELECT on the DB.
However I noted that we use too much valuelists for large tables, as each of them certainly result in such a SELECT. We will refactor them to picklists that fire only in the moment when the user actually uses them.

I also did this performance test with http://localhost:8080/servoy-admin/performance on startup and got again a lot of valueable information where we can improve things.
That tool is really a great help.

Happy to help and glad you have found ways to improve things.