Agile Developer

Urgent Issues with ...
 
Notifications
Clear all

Urgent Issues with Dropdown Functionality

3 Posts
2 Users
0 Reactions
246 Views
Posts: 609
Topic starter
(@banupriya)
Noble Member
Joined: 2 years ago

We are still experiencing slowness with the dropdown field, as previously noted. After reviewing the query's execution plan, we confirmed that data retrieval is efficient; however, the dropdown specifically is causing significant delays. This issue needs immediate attention. Additionally, we have another concern regarding the auto-select feature for dropdowns. When only one value is present, it should automatically select, but this functionality is currently not working, necessitating manual selection.

Issue 1: Slowness in Dropdown Field
While the query executes quickly, the dropdown process is leading to unacceptable delays, extending the RAS service order implementation time to approximately four hours. This performance bottleneck is critical, as the new application is ready, but the department cannot proceed efficiently, undermining their confidence. If unresolved, they may revert to the old system, which would negate the benefits of the new application.

Issue 2: Auto-Select Not Functioning
The auto-select feature for dropdowns with a single value is not operational, requiring manual intervention.

Could you please schedule a meeting with the team to address these urgent issues?


2 Replies
Posts: 602
Admin
(@axpertsupport)
Honorable Member
Joined: 2 years ago

If the slowness isn't consistent, it's probably not a coding issue. We should investigate potential database bottlenecks during those specific times. Generally, high-cost queries function well with one or two users but can cause significant CPU spikes with increased usage. In these instances, we need to optimize the query's cost to enhance performance.


Reply
Posts: 609
Topic starter
(@banupriya)
Noble Member
Joined: 2 years ago

Regarding the dropdown issue, we tested with another form that has only two or three fields, utilizing the same dropdown query. After entering more than 15 entries, we observed that the dropdown becomes slow and fails to load data. The data only reappears after signing back in or reloading the form. Please see the attached screenshot for reference.


Reply
Share: