[Waiting for user confirmation] Speed Issue

[Author]

Posts

[nicholasC-2]

Tell us what you are trying to do?
Ans: I am trying to finetune the speed. I use query monitor to see the query
SELECT SQL_CALC_FOUND_ROWS wp_posts.ID
FROM wp_posts
INNER JOIN wp_postmeta
ON ( wp_posts.ID = wp_postmeta.post_id )
INNER JOIN wp_postmeta AS mt1
ON ( wp_posts.ID = mt1.post_id )
INNER JOIN wp_postmeta AS mt2
ON ( wp_posts.ID = mt2.post_id )
WHERE 1=1
AND wp_posts.ID IN (8491,8490,8489,8488,8487,8486,8485,8484,8276,8274,8273,8272,8271,8270,8266,8007,8009,8011,8013,8015,8017,8019,8021,8023,8025,8031,8033,8032,8034,8036,8035,8037,8038,8040,8039,8042,8041,8043,8044,8045,8046,8047,8048,8049,8051,8050,8053,8052,8054,8055,8056,8057,8058,8059,8061,8060,8062,8064,8063,8065,8066,8067,8068,8070,8069,8071,8073,8072,8074,8075,8076,8077,8079,8078,8080,8082,8081,8084,8083,8085,8086,8087,8088,8090,8089,8092,8091,8094,8093,8095,8096,8097,8099,8098,8100,8101,8102,8103,8104,8105,8106,8107,8109,8108,8111,8110,8112,8113,8115,8114,8117,8116,8118,8120,8119,8122,8121,8124,8123,8125,8127,8128,8129,8130,8131,8135,8134,8136,8137,8138,8139,8140,8141,8142,8143,8144,8145,8146,8147,8148,8149,8150,8151,8152,8153,8154,8155,8156,8157,8159,8158,8161,8160,8162,8163,8164,8165,8167,8168,8169,8170,8171,8173,8172,8175,8174,8176,8177,8178,8179,8181,8182,8227,8228,8229,8231,8232,8233,8234,8235,8250)
AND ( wp_postmeta.meta_key = 'vacancy_total_count'
AND ( ( mt1.meta_key = 'longitude'
AND CAST(mt1.meta_value AS SIGNED) > '0' )
AND ( mt2.meta_key = 'latitude'
AND CAST(mt2.meta_value AS SIGNED) > '0' ) ) )
AND wp_posts.post_password = ''
AND wp_posts.post_type = 'preschool-centre'
AND ((wp_posts.post_status = 'publish'
OR wp_posts.post_status = 'private'))
GROUP BY wp_posts.ID
ORDER BY wp_postmeta.meta_value+0 DESC, wp_posts.post_title ASC
LIMIT 0, 21 /* From [ntucossstage.wpenginepowered.com/preschool/preschool-centres/] in [/nas/content/live/ntucossstage/wp-content/plugins/wp-views/embedded/inc/wpv-filter-query.php:825] */
WP_Query->get_posts

Time: 0.3958

How to simulate: First, click on the filter, filter by any of the option, click filter. Second, take note of the loading time. Finally, click on "Clear All" to rest the filter see the speed.

Is there any documentation that you are following?
No

Is there a similar example that we can see?

What is the link to your site?
link removed

[Minesh]

Hello. Thank you for contacting the Toolset support.

I would like to know where you find this query.

Are you using custom search and I see there is a post_password column in query as well as meta query.

The performance of the query depends how complex data structure you have and what exactly you want to search.

Can you please share all those required details and send me admin access details.

*** Please make a FULL BACKUP of your database and website.***
I would also eventually need to request temporary access (WP-Admin) to your site. Preferably to a test site where the problem has been replicated if possible in order to be of better help and check if some configurations might need to be changed.

I have set the next reply to private which means only you and I have access to it.

[Minesh]

Thank you for sharing admin access details but when I try to login using the shared admin access details it says the password is incorrect.

Can you please send me working admin access details as well as where I can see the speed issue with what post/page?

I have set the next reply to private which means only you and I have access to it.

[Minesh]

Thank you for sharing working admin access details.

When I checked I see you added custom code to "Custom Code" section offered by Toolset.
=> hidden link

I see you are passign the post__in argument. I do not have much to say here as the query build and what you see is completely as per your requirement and filters/hook you added usint custom code.