/
Sorting setting storage improvement ideas

Sorting setting storage improvement ideas

Owned by Alex
Last updated: Jul 10, 2013Version comment

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.