Changes between Initial Version and Version 1 of Ticket #31071, comment 28
- Timestamp:
- 12/01/2015 03:54:56 PM (9 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Ticket #31071, comment 28
initial v1 3 3 1) The post_type, post_mime_type index added the way @pento suggested (https://core.trac.wordpress.org/ticket/31071#comment:7) 4 4 5 2) The addition of "AND post_status = 'inherit'" to the months query (I see 3 variations on that query—see attached image) 5 2) The addition of "AND post_status = 'inherit'" to the months query. I see 3 variations on that query: 6 wp-admin/export.php:134, wp-admin/includes/class-wp-list-table.php:563, and wp-includes/media.php:3213 6 7 7 [[Image(https://d1zjcuqflbd5k.cloudfront.net/files/acc_6021/12t82?response-content-disposition=inline;%20filename=Screen%20Shot%202015-11-30%20at%205.44.09%20PM.png&Expires=1448923826&Signature=b-gIRiszhSp1CNkPQU3WUa3S0KNsg7qF2dzeHgB32jRXdc0xF5krGm2Q4Erj1uEbWnHROzcql28jR4rlyWsVJ4gDOup0WhHaJaBWlZTDGNgx97RAuLkeSa7FQywFKwkNFvHZfA-VTQQbyDqMgfRONBqHz0v4A1E-x9pEfFyV6h4_&Key-Pair-Id=APKAJTEIOJM3LSMN33SA)]] 8 3) If agreeable, I'd like to also add a caching layer around each of the audio, video, and months queries. 9