0033195: OBContext.initialize loading many objects from database. Review if some loads can be optimized away

Description

Reviewing SQL's done during insert into c_import_entry (i.e. via pos orderloader).

All the following SQL's were found to happen and all seems to come from OBContext.initialze (so probably at least once per http request)

Example flow starts from ImportEntryProcessor.setOBContext in case context is not yet cached.

1.) via OBContext.initialize()
select aduser0_.AD_User_ID
select adlanguage0_.AD_Language_ID
select adclient0_.AD_Client_ID
select adlanguage0_.AD_Language_ID
select organizati0_.AD_Org_ID
select warehouse0_.M_Warehouse
select adrole0_.AD_Role_ID_
select adrole0_.AD_Role_ID
select organizati0_.AD_Org_ID
select organizati0_.AD_Org_ID
select adclient0_.AD_Client_ID
select clientinfo0_.AD_Client_ID
select count(*) as col_0_0_ from AD_Language

Review if all loads are really needed or can be removed.
If all are needed maybe some sharing can be done in case input param (id requested is same for several loads of same table).

Also the last one (count from ad_language) is checking 'issystemlanguage='Y' which does probably not need to be repeated over and over again

Steps To Reproduce

Tags

Performance

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

Notes
There are no notes attached to this issue.

Issue History
Date Modified	Username	Field	Change
2016-06-08 16:48	shuehner	New Issue
2016-06-08 16:48	shuehner	Assigned To	=> platform
2016-06-08 16:48	shuehner	Modules	=> Core
2016-06-08 16:48	shuehner	Triggers an Emergency Pack	=> No
2016-06-08 16:48	shuehner	Tag Attached: Performance
2016-07-15 09:58	alostale	Status	new => acknowledged
2016-12-01 14:05	alostale	Priority	normal => urgent
2016-12-01 14:05	alostale	Priority	urgent => high
2022-02-01 08:05	alostale	Assigned To	platform => Triage Platform Base