ctrlaltdelete

hmm now i’m thinking on getting a cheap VPS to offload search with elastic search.
Thanks for the suggestion. Not sure if i’ll manage cos seems very complicated.

The other monster queries are from “beautiful taxonomy filters”..i have no idea how big sites do it. Certainly not with that plugin.

Hello thanks for the info. I added:
add_filter( 'related_posts_by_taxonomy_id_query', '__return_true' );
Everything seems to work so i’ll use it.

I have these queries that aren’t very fast, does the above filter helps with that or it’s something else?

# Query_time: 0.426876  Lock_time: 0.000090 Rows_sent: 0  Rows_examined: 0
SET timestamp=1548164968;
INSERT INTO 'wp_postmeta' ('post_id', 'meta_key', 'meta_value') VALUES (134484, '_rpbt_related_posts:6375249561307eaaeef25731acbb4f17', 'a:2:{s:3:\"ids\";a:8:{i:134931;s:1:\"3\";i:134479;s:1:\"3\";i:123545;s:1:\"3\";i:137687;s:1:\"2\";i:137220;s:1:\"2\";i:137179;s:1:\"2\";i:136913;s:1:\"2\";i:136687;s:1:\"2\";}s:4:\"args\";a:3:{s:7:\"post_id\";i:134484;s:10:\"taxonomies\";a:2:{i:0;s:5:\"genre\";i:1;s:9:\"publisher\";}s:13:\"related_terms\";a:3:{i:0;i:4;i:1;i:55;i:2;i:27;}}}');

• This reply was modified 7 years, 4 months ago by ctrlaltdelete.

The format is solved i think.

I got a slow query from the plugin that doesn’t go away even with caching enabled:

time varies from 0.05~0.1

get_crp_posts_id()

SELECT DISTINCT wp_posts.ID 
FROM wp_posts 
WHERE 1=1 
AND MATCH (post_title,post_content) AGAINST ('Shin Megami tensei if...') 
AND wp_posts.post_date < '2018-10-25 19:51:51' 
AND wp_posts.post_date >= '2015-10-26 19:51:51' 
AND wp_posts.post_status = 'publish' 
AND wp_posts.ID != 115618 
AND wp_posts.post_type IN ('post') 
LIMIT 0, 6

I want to mention that my post_content is EMPTY i only use custom fields no content.
I also don’t use the post type ‘post’ and dates aren’t a factor, all posts are equally relevant. I don’t understand what this query is doing but can i speed it up or get rid of it?

Hello i am using a child theme.
With that function they display one under the other (instead of side by side) but still show a lightbox when clicked.

Is there a way for me to make my own html from scratch? I only need post titles, permalink and thumbnail url. I’d like to do the rest myself if possible.

But i’m scared to lose the plugin cache which is a must else the query isn’t fast enough.

Hi, im glad you are back!
I’ve tried to go back to 2.3.1 but query monitor says “Ajax deprecated” and it won’t work properly any more either, i think WordPress updated and made it obsolete.
So we are stuck without this imo essential feature because: why would you want to have people wasting time choosing combinations that have 0 results?

Hi could you help me a bit i don’t think i understand how to do this properly.
So i have a function that adds languages (which is a custom tax) into the titles of the post. I use it like this to apply it yoast seo breadcrumb titles:
add_filter( ‘wp_seo_get_bc_title’, ‘add_langs’, 10, 2 );
OR directly on the theme like so:
add_langs($title)

Now i want to apply this function to the titles on the related posts plugin. So i tried:
add_filter( ‘crp_title’, ‘add_langs’, 10, 2 );
Cleared the related posts cache but it didn’t work.

Is it possible for me to do this somehow?

• This reply was modified 7 years, 10 months ago by ctrlaltdelete.