I am using Oracle apex 20.2 on Chrome
I am have an Interactive Grid with following query . Pulling data from a single table. The orginal query is only following
select ,,.,, from MY_BALANCE_DETAILS
where 1=1
AND HEADER_ID = :P5_HEADER_ID
*****************************************************************************
The table has 347870 total rows . With the original query When I run the Grid for a particular Header_id it takes 3-4 seconds maximum.
Now my users wanted 2 additional filters( the reason is cascading lov columns dont have filters) . So I added 2 drown down popup lovs above the grid which has null value when page load. So users can select the filters and press a button to apply filters . This part working fine.
However on page load, The filters are null , so I want to load all data for that particular Header_id selected. So I added two lines in the where clause like following . But when I added this lines, the Grid takes 30 seconds to load (page load with filter has null value) . The same query( modified with filters) in Toad takes only 200 ms. Am I doing anything wrong. What I need to improve the performance of the Grid.
select ,,.,, from MY_BALANCE_DETAILS
where 1=1
AND HEADER_ID = :P5_HEADER_ID
AND PROJECT_ID = nvl(:P5_PROJECT_LIST_F, project_id)
AND ORGANIZATION_ID = nvl(:P5_ORG_LIST_F, ORGANIZATION_ID)
Please help
I am using Oracle apex 20.2 on Chrome
George