0035989: Default session values calculation on login is slow having a big amount of organizations

Description

The calculation of the default session values (values for the table with a 'is default' column) on login is slow having a big amount of organizations

Steps To Reproduce

1) In an environment with 1000 organizations at least, do log-in.
2) Check the amount of time spent in the LoginUtils class when calculating the default values:

DefaultSessionValuesData[] ds = DefaultSessionValuesData.select(conn);

Notice that the calculation of the default values inside the LoginUtils.fillSessionArguments method is expensive (see attached image with a performance screenshot)

Tags

Performance

Attached Files

DefaultValuesPerfScreenshot.png [^] (91,920 bytes) 2017-05-15 10:18

Relationships [ Relation Graph ] [ Dependency Graph ]

related to	feature request	0035553	closed	caristu	Improve scalability of the login process
related to	defect	0033602	new	Triage Omni OMS	LoginUtils.fillSessionArguments (query Attribute.selectOrgCurrency quite slow) around 100ms with many orgs
related to	design defect	0035990	new	Triage Platform Base	Sqlc calculates all records to retrieve later the first result

Notes
(0100664) shuehner (administrator) 2017-11-22 12:37	Other related comments. Checking manually the output of that query i think in some cases it runs for table where i don't see a functional sense. I.e. ad_model_object_mapping has a isdefault column however that is just default inside the parent entry ad_model_object. And that sql above apperently finds the primary key value for 'the' default row without context. Which i doubt is useful (for that specific table).

Issue History
Date Modified	Username	Field	Change
2017-05-15 10:18	caristu	New Issue
2017-05-15 10:18	caristu	Assigned To	=> platform
2017-05-15 10:18	caristu	Modules	=> Core
2017-05-15 10:18	caristu	Triggers an Emergency Pack	=> No
2017-05-15 10:18	caristu	File Added: DefaultValuesPerfScreenshot.png
2017-05-15 10:23	caristu	Relationship added	related to 0035990
2017-05-15 10:24	caristu	Relationship added	related to 0035553
2017-05-15 11:10	caristu	Tag Attached: Performance
2017-05-29 13:08	shuehner	Issue Monitored: shuehner
2017-11-10 11:21	caristu	Relationship added	related to 0033602
2017-11-22 12:37	shuehner	Note Added: 0100664
2017-11-23 13:11	caristu	Status	new => acknowledged
2017-11-23 13:11	caristu	Steps to Reproduce Updated	View Revisions
2022-02-01 08:08	alostale	Assigned To	platform => Triage Platform Base