You need to either read more about database optimization or hire a specialist and distribute those posts possibly on multiple database and file servers.
Even if you build a custom solution it would be slow so don’t blame WP.
Related Posts:
- Uploading images to Media Library fails with Memory Exhausted
- When Uploading JPEGs, Does WordPress Compress the Original Image?
- Faster way to put images into a blog post by using Add Media dialog
- Disable lazy loading on specific images
- Rebuild thumbnails via WP Cli – how?
- Deleted Image giving a 301
- Media Library Cleanup A Thought Exercise
- Is is possible to append .webp to srcset images using wp_filter_content_tags()?
- Could a very long article slow down all website and wpadmin?
- remove or update add_image_size
- get the attachement url for the medium sized image
- Each custom image size in custom upload directory?
- Is there a simple way to just insert a link to an image (without inserting an image)?
- Watermarking Images with WordPress with WP_Image_Editor
- Get attachment/image info in JS
- Auto-modifying original [full size] images
- Get attachment ID of author_meta image – Attachment Metadata
- Black and White thumbnails
- Crop image to horizontal or vertical by code based on image size
- Link to File URL by default
- How to Display an Image Uploaded through a Meta Box in a Template?
- Media sizes aren’t being created – server config?
- Drag images with caption in WP editor
- Responsive background images added inline
- How to make programmatic image upload generate thumbnail and sizes?
- Any way to “combine” galleries or show multiple galleries as one?
- How to remove buttons from gutenberg toolbar
- Get full image array
- Display number of images actually posted
- Confusion about arguments sent to add_image_size
- change the $content_width
- media_sideload_image with rewritten urls?
- Different image sizes for home and post pages
- Show full image thumbnail
- How to set a contact forms total size limit
- Get thumbnail url of custom meta image?
- SVG Featured image not shown in twitter
- upload featured image in custom post type from frontend
- Make medium_large images available to insert into post
- WooCommerce-like featured gallery
- How to use photo in multiple posts?
- Creating a thumbnail from an image already on the server?
- Images not showing on blog
- Alter the image, before save, of a particular image size
- Why does Google Image Search still display my images?
- Dynamic tagged image galleries
- Hero image cropped at different dimensions
- WP fails to upload files to media library, /wp-admin/async-upload.php 403 forbidden
- How to handle a background-size: cover image in WordPress?
- Empty alt/title form check in media library
- Images stopped loadding after adding SSl
- How To Get The File Extension Of Images Having Different Extensions In A Directory?
- GoDaddy Number of Image Files Per Directory Exceeded
- add_image_size wont work after get_intermediate_image_sizes
- Ways to show multiple, separate galleries per post?
- How to get the image-URL from Media-Upload in a post?
- One of my image sizes isn’t showing up in srcset
- Featured Image Cetegory Not Shown In WordPress
- after migration, newly uploaded images won’t show up
- Why do I have blury images in WordPress
- Disable save as image on smartphones using all browsers ( chrome, firefox, ie, cm, opera )
- limit number of images shown from gallery
- Alter the image used for a user who has not uploaded a custom image yet
- Allow users to upload multiple images to their profile
- how to change format jpg to webp?
- Allow a specific user role I have created to only upload one image to his media library
- Implementing a modal(lightbox) for all images in all post-gallery posts
- how to regenerate webp et-pb-portfolio-image
- How to increase media image scale limit?
- How do I avoid color distortion of uploaded images?
- Where to put code that customizes API
- Force WordPress to always generate a thumbnail for original image
- When upload a PNG a noise appears in the thumbnails
- How to auto add image caption from image alt?
- File upload size limit in wordpress and php.ini limit
- Blank image thumbnails in media library
- Getting extra image links in code with wp_get_attachment_image
- Get “Image CSS Class” value from the Advanced Options section
- After reinstalling wordpress images do not appear in posts?
- Dinamically modifying attributes of images on posts
- Run command to optimize images after they get uploaded to WordPress
- Show images from TEXT section on PAGE wordpress
- Where to add my code to auto attach images to existing products
- Large size is not honoured when inserting image
- If file exists with page slug name show image else nothing
- Issue uploading images
- How can I use images that are on the server locally?
- Image filter works on attachement pages but not posts. I can’t get the image ID
- The most of the images don’t appear, although URLs are correct
- Get images uploaded to this post in popup on editor screen
- Remove “align” attribute on images
- Paginate Gallery [closed]
- How do I add a nested conditional within an echo – to use a default image if there isn’t one in the post?
- WordPress: Preload next post images
- How do I change a Themes Header Image?
- Blurry Images WordPress 5.8.1
- Why is inline CSS added to images automatically? [closed]
- How to show file size of featured image? [duplicate]
- Images uploaded in customized gallery do not link to media
- WordPress Site Broken and it gives Headers Already sent error