Solved

PLSQL query runs in four seconds but Lobby Element times out

  • 24 February 2020
  • 4 replies
  • 260 views

Userlevel 6
Badge +13
  • Hero (Customer)
  • 346 replies

I have a created a Lobby element which is timing out.  I am logged on as user IFSAPP.  The result is the same for two other users.  The PL/SQL query behind the element returns the FIVE records in FOUR seconds

select

contract,

part_no,

ifsapp.inventory_part_cfp.Get_Cf$_Qty_Demand (contract,part_no) qty_demand

from inventory_part ip

where ip.PART_STATUS = 'C'

and ip.CONTRACT = 'PCT'

and ifsapp.inventory_part_cfp.Get_Cf$_Qty_Demand (contract,part_no) >0

 

The Lobby Data source I have created with the same query takes 90 seconds to populate with either “&AO” or “ifsapp” prefix

 

The Lobby element times out and doesn’t return any data after 2 minutes.

The Custom Field referred to is using a select statement:

select ipa.qty_demand from ifsapp.INV_PART_CONFIG_PROJECT_ALT ipa
where ipa.contract = :contract and ipa.part_no = :part_no

Does anyone have any suggestions why the disparity or how to resolve?

Many thanks!

 

icon

Best answer by anmise 25 February 2020, 07:23

View original

4 replies

Userlevel 6
Badge +13

Lobby data source

 

Userlevel 7
Badge +21

Would it help to prepare an IAL that is always live?

Selection on inventory part view/table would then be less intensive.

Userlevel 7

Is the custom field necessary? Otherwise you could try to do something like this.

SELECT contract,
part_no,
qty_demand
FROM ifsapp.inv_part_config_project_alt
WHERE inventory_part_API.get_part_status(contract, part_no) = 'C'
AND contract = 'PCT'
AND qty_demand > 0

The INV_PART_CONFIG_PROJECT_ALT view has a lot of joins and get functions, so it’ll take some time to run. 

 

Userlevel 6
Badge +13

Thanks for the alternative views; INV_PART_CONFIG_PROJECT_ALT wins the day!

Reply