Database performance improvement

[Gormartsen]

Guys, I am doing a performance review on 1.x branch and noticed that we are missing few important indexes or some extra caches could be implemented.

I will create PR and update this issue with details when PR ready.

[jenlampton]

Any progress on this? I would love to get some performance improvements into 1.6 :)

[Gormartsen]

Not yet. I took side road with #2400 =)

[jenlampton]

How about now? :D

[Gormartsen]

Tnx for remind me. I will try to update it on this weekend. If nothing, tag 1.6.0 could be removed.