Python-сообщество

        # Получить обекты модели MsgTxt, которые нам нужны
        mt = MsgText.objects.filter(msg__page__name=page,lang__name=lang)
        # Упаковать полученную информацию в словарь
        out = {}
        for ob in mt:
            out[ob.msg.name] = ob.text
        return out

SELECT ..... WHERE "multilang_msg"."id" = 14

mt = list(MsgText.objects.filter(msg__page__name=page,lang__name=lang))

    def get_msgs(self,page,lang):
        from django.db import connection, transaction
        cursor = connection.cursor()
        cursor.execute("""
SELECT msg.name,mst.text 
FROM multilang_msgtext AS mst, multilang_msg AS msg, 
multilang_page AS mp, multilang_lang as ml
WHERE mst.lang_id=ml.id AND mst.msg_id=msg.id AND msg.page_id=mp.id
AND ml.name=%s AND mp.name=%s;
""",(lang,page))
        out = {}
        while(1):
            row = cursor.fetchone()
            if(row == None):
                break
            out[row[0]] = row[1]
        return out

                    Количество                       Количество             Среднее время
                    элементов                         запросов            генерации страницы
Старый код:            12                                      13                     ~300ms
Новый код:             12                                      1                     ~150ms

SELECT "multilang_msgtext"."id", "multilang_msgtext"."lang_id", "multilang_msgtext"."msg_id", "multilang_msgtext"."text" FROM "multilang_msgtext" INNER JOIN "multilang_lang" 
ON ("multilang_msgtext"."lang_id" = "multilang_lang"."id") INNER JOIN "multilang_msg" ON ("multilang_msgtext"."msg_id" = "multilang_msg"."id") 
INNER JOIN "multilang_page" ON ("multilang_msg"."page_id" = "multilang_page"."id") 
WHERE ("multilang_lang"."name" = E'Russian' AND "multilang_page"."name" = E'site_header_1' )

.....
SELECT "multilang_msg"."id", "multilang_msg"."page_id", "multilang_msg"."msgnum", "multilang_msg"."name", "multilang_msg"."comment" 
FROM "multilang_msg" WHERE "multilang_msg"."id" = 20
.....