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:
| Code Block | ||
|---|---|---|
| ||
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
instead of 4, then we save 3 requests to database each time.
--
Best Regards,
...
Related Tasks
| Jira Legacy | ||||
|---|---|---|---|---|
|