Just a question. On my sites it has become much slower. Download time is 30 seconds per 30 thousand lines. I have to say that queries are not optimized, so 10k queries can be started, but still, I find it too long ... So I decided to let it check the indexes. After looking at some “problematic” tables, I saw that I made an index on several columns, but the power is displayed only in 1 column, and the rest of the indexes have a power of 0.
Did I make the wrong indexes? In other words, should I do an index for each column, and not combine them?
source
share