Research and apply DB improvements

Uncategorized

Existing indexes were updated in such a way that they follow this rule: "Put columns that will be the most selective at the beginning of the index declaration".

Different scenarios were run to measure performance before update indexes and after update. In most cases the results show worse performance after update indexes. But there where individual cases (like opening item, opening list with few items) where performance was better after update indexes.