[Resolved] slow query

[Author]

Posts

[mantasM]

Tell us what you are trying to do?
our site is very slow. debug tool identified one of your DB queries as taking sometimes 5-10 seconds to execute.

here's an example:

# Time: 2023-11-30T14:16:29.445795Z
# User@Host: thepornmapcom[thepornmapcom] @ [127.0.0.1] Id: 1406565
# Schema: wp_thepornmapcom Last_errno: 0 Killed: 0
# Query_time: 5.704644 Lock_time: 0.000001 Rows_sent: 100994 Rows_examined: 100994 Rows_affected: 0 Bytes_sent: 3630029
SET timestamp=1701353783;
SELECT * FROM wp_postmeta WHERE post_id IN (1485,10879,3088,26766) /* From [thepornmap.com/list/best-pay-porn-sites/] in [/nas/content/live/thepornmapcom/wp-content/plugins/types/vendor/toolset/types/embedded/classes/loader.php:85] */;

what do you recommend to do to solve this issue?
thank you

[Minesh]

Hello. Thank you for contacting the Toolset support.

I review the information you shared and as you can see it says:
Rows_sent: 100994 Rows_examined: 100994

That means more than one lakh (100994) entries are scanned and send by server. Even without Toolset if you run the query it should have the same impact as those are the too many number of rows/content you are trying to fetch using the query.

Are you using view to display the records? if yes, I suggest you should use pagination to split total number of rows into pagination and if you have such large content then we can not do much here and you may try to use cache plugins and check if that helps.

More info:
- hidden link
- hidden link
- hidden link