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.

--
Best Regards,

http://www.in-portal.com
http://www.alex-time.com