Hi all,
We're using APEX 24.2.2.
On page 0, we have a ‘Select one’ item in the navigation bar, to search a customer. That works like a charm, but lately we find that the pages start rendering slower. After examinating the debug log, we see that on page load, the query of the select one item is executed. When I run a page with debug level 1, I see:
With level 9, I also see:
I have defined the item as follows:
- Name: P0_SEARCH
- Type: Select One
- Maximum values in list: empty
- Fetch on search: On
- Use Cache: On
- Value HTML expression: added some html
- Match type: Contains
- Case Sensitive: Of
- Minimum Characters: 3
IMHO the query doesn't have to be executed on rendering. Can I influence that? I thought that Fetch on Search meant, that only after entering 3 characters, the search query is executed.
When I change the item type to Popup LOV, the query isn't executed on rendering…