Anonymous | Login | Signup for a new account | 2024-05-01 17:22 CDT |
Main | My View | View Issues | Change Log | Roadmap | Docs | Wiki | Repositories |
View Revisions: Issue #1106 | [ Back to Issue ] | ||
Summary | 0001106: Sorting setting storage improvement ideas | ||
Revision | 2011-10-14 02:27:30 by alex | ||
Description | 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 in "FieldName1,order1|FieldName,order2...." format, then we: 1. save 3 requests to database each time |
||
Revision | 2011-10-14 02:26:40 by alex | ||
Description | 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 in "FieldName1,order1;FieldName,order2...." format, then we: 1. save 3 requests to database each time 2. will use same code to process sorting settings as "sort_by" tag parameter. |
||
Revision | 2011-10-14 02:26:40 by alex | ||
Additional Information | Plan: 1. code to be changed is located in kDBEventHandler 2. idea is to replace 4 calls to getListSetting/setListSetting method with 1 call (to each method) |
||
Revision | 2011-10-13 22:52:08 by alex | ||
Additional Information |
Main | My View | View Issues | Change Log | Roadmap | Docs | Wiki | Repositories |
Web Development by Intechnic In-Portal Open Source CMS |