Oracle JDeveloper (MOSC)

MOSC Banner

Improving LOV Performance with Large Dataset in JDeveloper 12.2.1.3.0

in Oracle JDeveloper (MOSC) 3 commentsAnswered

Hi Community,

We are currently using JDeveloper 12.2.1.3.0 and facing a performance issue with an LOV that contains around 10,000 records. When users click the dropdown (based on af:inputComboboxListOfValues / LOV component), it takes significant time to load, which is impacting the user experience.

Requirement

To improve performance, we are considering implementing a progressive loading (pagination-like) approach:

  • Initially load only 10 records when the dropdown is opened.
  • Display a "Load More" option at the bottom of the list.
  • When "Load More" is selected, fetch the next 10 records and append them (without fully reloading the component).

Challenge

During our research, we found that:

  • af:inputComboboxListOfValues

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center