Buddypress queries doing things “the hard way” (using wrong index)
I updated my BP from 3.2.0 to the latest version (I don’t think this is the culprit). I transferred servers from A to B, same MariaDB version.
On both server A (old BP 3.2.0) AND on my local installation (using newest BP), queries run fine.
On my new server B, some queries (simple ones) are taking 5-7+ seconds (vs 0.002s etc).
This screenshot sums it up: https://i.imgur.com/BvPahI0.jpg
It’s using different indexes on the new server…and as a result, doing things the hard way. I was able to remedy the above query by hacking around and able to grab that particular query via an
add_filter("bp_activity_paged_activities_sql")and adding a
USE INDEX(date_recorded)into it.
But many, if not all BP queries, are doing the same thing.
PS the bp_activity table is identical across all servers I mentioned above, including the indexes.
Any “easy” solution? It’s killing my server’s performance.
- You must be logged in to reply to this topic.