How to load large number of data oj-select-single.. please suggest for alternatives.

User_P8BY0

Hi

In my project , using editable table, fields- colu1, clou2, map1,map2 and colu1 having oj-select-single dropdown, and same as map1, need to match colu1(dropdown value) to map1(dropdown value),

map1 dropdown, I am getting 10k records.. that time my page is hanging. what is the best way to

load the data.. or any design suggestions or component changes.. Please suggest me..

Ojet 9.2.0

Thanks

Nathan Zentner

Not sure if the issue is OJet related, but instead data pull related. You should filter that list down.

You could use a oj-input-search and give a small list of examples for people to start with. If they choose to type in text, then you can pull the content filtered. Maybe save the selected items in the short list as a "recently used" if the use case requires that they choose the same element for multiple rows.

https://www.oracle.com/webfolder/technetwork/jet/jetCookbook.html?component=inputSearch&demo=suggestions

John 'JB' Brock-Oracle

This is going to be all about the DataProvider that you are using to bind the data to the oj-select-single component. If you are trying to drop a straight array into the component that will never work.

Are you downloading all 10k of data in one REST call? or are you using a REST service that supports pagination?