Skip to main content

New answers tagged

1 vote

Do Seeded Orderby Rand Queries Benefit from DB Caching?

Looking at the source of class-wp-query.php (ie, the WP_Query code), I find this: /* * Ensure the ID database query is able to be cached. * * Random queries are ...
Pat J's user avatar
  • 11.8k
0 votes

Disable creating sort index SELECT post_modified_gmt

Searching on Google for the mentioned query, I believe your assumption that it is coming from WordPress is correct. This ticket can be found at https://core.trac.wordpress.org/ticket/31171. In my ...
Denis Florin's user avatar
0 votes

Deleting WordPress posts and media files based on author via MYSQL database

This is what I wanted to achieve, I hope it helps somebody DELETE wp_posts FROM wp_posts INNER JOIN wp_users ON wp_posts.post_author = wp_users.ID WHERE post_author = 1 AND post_date BETWEEN '2024-...
Lal Prasanth's user avatar

Top 50 recent answers are included