/
Sorting setting storage improvement ideas
Sorting setting storage improvement ideas
Imported From: http://groups.google.com/group/in-portal-dev/browse_thread/thread/4b3cb3e55be89fa4#
In Admin Console In-Portal makes 4 requests to database during each list-style template display. For example on Phrases list such requests are made:
SELECT VariableValue, VariableName FROM PersistantSessionData WHERE VariableName = 'lang_Sort1.' AND PortalUserId = -1 LIMIT 0,1 SELECT VariableValue, VariableName FROM PersistantSessionData WHERE VariableName = 'lang_Sort1_Dir.' AND PortalUserId = -1 LIMIT 0,1 SELECT VariableValue, VariableName FROM PersistantSessionData WHERE VariableName = 'lang_Sort2.' AND PortalUserId = -1 LIMIT 0,1 SELECT VariableValue, VariableName FROM PersistantSessionData WHERE VariableName = 'lang_Sort2_Dir.' AND PortalUserId = -1 LIMIT 0,1
If we change sorting to be stored in one persistent session variable instead of 4, then we save 3 requests to database each time.
Related Tasks
Error rendering macro 'jira' : Unable to locate Jira server for this macro. It may be due to Application Link configuration.