Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Performance-Problems in Grid

Evi MerSep 12 2023 — edited Sep 12 2023

Hi,

we have massive performance problems in pages with grids and complex structure. This cannot be replicated in the trial, as we also don't know what exactly triggers this slowness. The grid mirrors its data into an editable form. By design no changes can be made in the grid itself.
When only a few records are displayed (less than 200), editing within the page works quite well. With about 1000 records, editing is almost impossible. The selection takes about 100 s until the result is displayed. Even worse is that now in the form the selection e.g. from a yes/no-list takes about 20 s (with only 200 records it needs only 3 s). At debug level 6 I can't see much in the debug messages. In the file for Gridselect for each record two entrys appear: ….FX_P_UTILS.AUTH_CONDITION_CHECK_BOOL ….

No Idea, why this function is called so often.

and

“Column record not found in the meta data: SEARCH_STRING”,"6" ….
SEARCH_STRING is no field in my grid!

I have attached the exports of debug messages for Gridselect and LOV-Select.
Also a screenshot of the application page is attached.
As to mention too: the Developer Tools show 266 errors. All of them: "Incorrect use of <label for=FORM_ELMENT". I can't find the cause for this either (see screenshot). I don't know whether this belongs to the performance problems.

debug_message_data_Gridselect_1207_Records.csv

debug_message_data _LOV_Selection.csv

Can you please have a look on this?

This totally slows us down in the replacement of Forms to FOEX for our customers.

Thanks in advance.

Best regards

Eveline

Comments
Post Details
Added on Sep 12 2023
2 comments
237 views