Plugin Author
Ajay
(@ajay)
Can you tell me how you’re tracking page generation time. I have had a few others who have raised this issue but I haven’t been able to replicate this.
Are you in a position to test this addon – https://github.com/WebberZone/top-10-fast-tracker
I used Query Monitor plugin for that.
Plugin Author
Ajay
(@ajay)
Can you take a look at what the Query by components is and then what Top 10 queries are and which specifically could be triggering the long times?
Worth also checking load times after disabling the trackers in the settings page (one at a time)
It’s all about SQLs.
View post on imgur.com
I just leaved only one call of:
$top_posts0 = get_tptn_pop_posts( array(
'limit' => 6,
'strict_limit' => false,
'post_type' => 'artist'
));
without any further calls (order by postnumber, loop, etc.). And just getting top posts took 3.8s:
View post on imgur.com
And I’m not sure why does it look in all post types while I ask to show me certain 'post_type' => 'artist'
Note: my database is huge ~500.000 posts, but not so huge for these numbers.
If I were developing a such plugin, I would save the counter to post meta or even directly in wp_posts table (it is probably against to wp concept, but who cares) to have a good performance (I guess).
As far as I remember INNER JOINs are evil.
Plugin Author
Ajay
(@ajay)
I am not sure, but there might be a few plugins that do save the count in the posts table.
Even with the inner joins, this shouldn’t be that slow. Can you please check that the PRIMARY KEYs of the table are correct? There were issues with previous versions where the keys broke cause of an upgrade.\
You might need to recreate the keys – there are buttons in the Tools page that let you do this. Another option is to recreate the entire tables – again a button for that.
However, please do backup the tables (and ideally whole db) before making the change.
