The idea is to have some index/indexes (secondary database tables) that would store data needed for presenting lexeme for display, e.g. lemma, language item reference, and lexical category item reference, so for presenting the lexeme (as the value in the statement) it is not necessary to load the whole lexeme data blob from the database.

This task involves drafting the structure of such index/indexes, and then storing the relevant data when lexeme data is modified. Those activities are going to be tracked as individual subtask of this one.

Priority of this task might become lower based on the outcome of T188108.