Testing is the only way to be sure, but my guess would be that it is not the query itself that is slowing the page load. After you have fetched those 2000 records, you are looping through them. Every time you call get_template_part. This function in turn calls locate_template, which leads to load_template, where you … Read more
That table is from the redirection plugin, and isn’t a part of WordPress Core. Deleting it should have no ill effects as long as you disable the plugin too. If you wish to continue using that plugin though, I recommend using the plugin authors support at https://wordpress.org/support/plugin/redirection/
Just to put here the suggestion that came up after discussing the requirement on chat. Due to the complexity of user filtering/search required, the wordpress user data tables is not a very good place to store the user’s attributes. Instead it will make more sense to have a CPT and related taxonomies to store the … Read more
Speed up a wordpress site is not a MySQL settings issue. One site in order to perform well is to USE MySQL with the best efficient way (limit your queries results, get only what you need) Default wordpress database schema have been already set up (primary keys, indexes e.t.c) to be used by the default … Read more
How can I measure the performance of any WordPress Plugin or Theme?
Performance issues with large website [closed]
Mysql / WordPress killing my server with 80k users [closed]
Try this plugin: http://wordpress.org/extend/plugins/p3-profiler/
There’s a free to download ‘lite’ version of the GDPress Tools plugin that may sort you out, but it’s probably preferable and more accurate to use XDebug + KCachegrind. FWIW, the latest build of PHPStorm integrates with XDebug’s profiler to handle the data presentation and visualisation side.
Yes, use caching. But even with caching you should rethink what you are actually doing because the cache for page/2 should change every time you publish a new post which might make caching pointless depending on the amount of traffic to that page. You should probably rethink what you are trying to achieve there, why … Read more