Sorting setting storage improvement ideas

[Alexander Obuhovich]

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

[Phil -- wbtc.fr --]

I like request optimizations :)

2011/7/5 Alexander Obuhovich <aik....@gmail.com>

[Alexander Obuhovich]

If we store all sorting like this: "FieldName1,order1;FieldName,order2....", then we could use same code to process them and "sort_by" tag parameter.

Dmitry, what's your opinion on this?

[Dmitry A.]

Hi Alex,

Yes, I like and support your idea for improvement.

What's the amount of work is involved here?

DA

[Alexander Obuhovich]

1.5 h work at most.

I've also noticed, that such 4 queries (to retrieve sorting settings) are performed for each list being displayed on front-end (links, categories and so on).

[Dmitry A.]

Hi Alex,

Great. Please create a task for this.

DA

[Alexander Obuhovich]

Task: http://tracker.in-portal.org/view.php?id=1106