Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Revisions: Issue #37324 All Revisions ] Back to Issue ]
Summary 0037324: slow login having many preferences
Revision 2017-11-20 13:00 by alostale
Description In a system with some thousands of preferences, depending on how they are distributed, login (both in back-office and POS) can last up to some seconds.

Two different cases detected with different configurations:

== Case 1: many visible preferences ==
Thousands of preferences visible from the client/org/role that is performing the login. Testing this case with 8K preferences defined at system level, login requests took up to 40s.

This case, even possible, it's a bit hypothetical, not that probable to occur in a real instance.

== Case 2: preferences defined in readable org, but not visible due to "visible at org" field ==
Having thousands of preferences defined on an organization that is in the parent tree of the one that is used for current login, login time takes up to extra 2s even those preferences are set as not visible through the "visible at org" field.

This case can occur for example in a real instance with many (in the steps emulating 500) organizations all of them children of a common parent. Preferences are defined in parent one, and visibility limited of each of the children.
Revision 2017-11-20 12:51 by alostale
Description In a system with some thousands of preferences, depending on how they are distributed, login (both in back-office and POS) can last up to some seconds.

Two different cases detected with different configurations:

== Case 1: many visible preferences ==
Thousands of preferences visible from the client/org/role that is performing the login. Testing this case with 8K preferences defined at system level, login requests took up to 40s.

== Case 2: preferences defined in readable org, but not visible due to "visible at org" field ==
Having thousands of preferences defined on an organization that is in the parent tree of the one that is used for current login, login time takes up to extra 2s even those preferences are set as not visible through the "visible at org" field.


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker