rare sql query very often

Posted in: Newspaper
Post count: 45
news_lp_client
#208798
Dec 28, 2017 at 4:14 pm

Hi, i want to know if anybody have knowledge of this query that appear very often in my mysql log.


| Query | 1 | Copying to tmp table | SELECT SQL_CALC_FOUND_ROWS News_posts.ID FROM News_posts LEFT JOIN News_term_relationships ON (News_posts.ID = News_term_relationships.object_id) WHERE 1=1 AND (
News_term_relationships.term_taxonomy_id IN (30)
) AND News_posts.post_type = 'post' AND (News_posts.post_status = 'publish') GROUP BY News_posts.ID ORDER BY News_posts.post_date DESC LIMIT 138030, 10 |

Post count: 45
news_lp_client
#208799
Dec 28, 2017 at 4:20 pm

The LIMIT is really big!!!

Post count: 20688
Simion C.
#208878
Dec 29, 2017 at 9:20 am

Hi,

I found some related topics, but maybe some more experienced users could share their point of view in the matter
– https://stackoverflow.com/questions/4481388/why-does-mysql-higher-limit-offset-slow-the-query-down
– https://mariadb.com/kb/en/library/limit-rows-examined/
– https://dba.stackexchange.com/questions/69537/limit-1000-25-vs-limit-25-offset-1000

Thanks

Viewing 3 posts - 1 through 3 (of 3 total)
The forum ‘Newspaper’ is closed to new topics and replies.