Table Grid Editor - Big lists are incredible slow

[Mads Stavang]

Hello,

One of my columns is of type list, and I use a datasource to fill the list with values. The query returns around 4800 entries. It is a list of hw parts, and each entry contains a part number and the description. The use case is that the use should be able to type in either a part number, or part of the description to narrow down the list of items.

Because the list is so big, the GUI is very slow. Do you have any suggestions on how to optimize this?

[francis · Accepted solution]

Hi Mads,

The reason is that the drop down list is loaded with all the entries resulting from the query.  

There are ways to circumvent by cascading from one field to the other - but we know this is a workaround

Could you forward your case to support dot tge at idalko dot com, such that we can keep you up to date re: a better solution 

Thanks

Francis

[Mads Stavang]

Thanks for your reply. I will do so.