How to prevent WordPress from retrieving data for the last 10 posts in the database?

The reason is you are visiting the home page and it contains the WordPress Loop like below to query 10 recent posts.

<?php
if ( have_posts() ) :
    while ( have_posts() ) : the_post();
        // Your loop code
    endwhile;
else :
    // not found template
endif;
?>

The number of posts can be managed from settings->reading->Blog pages show at most. from WordPress dashboard.
There you will see 10 posts selected in the value. if you want to display 5 posts then change this value.

if you want to remove this query from home page then edit index.php, frontpage.php or home.php file depending upon your theme. Recommended way is to create a page template and do your thing there. how to create page template in WordPress

Related Posts:

  1. get_results using wpdb
  2. Count & Display Database Queries
  3. Export wordpress table to excel
  4. How best to inject ads between posts in the loop?
  5. Change SQL get_results to search for posts with custom term in custom taxonomy
  6. Change all http to https in mysql databse?
  7. WooCommerce – Query for ordered products
  8. PHP variable in WordPress database query
  9. Delete duplicate rows from wordpress database where a column is duplicate in phpmyadmin
  10. Query WordPress database by registered date and role
  11. Query from a different database than the default
  12. How to query the WordPress database to get posts of a certain custom post type, taxonomy and field?
  13. Select Multiple meta_value from WP DB; Single Query
  14. CRUD operations using WordPress database API
  15. Hook directly into query execution
  16. Advanced SELECT query with condtional statements
  17. Select two sums with single get_var statement
  18. Replace/Mute/Stop Search Query
  19. Slow queries constantly getting stuck on WordPress database of ~100,000 posts
  20. cache specific data?
  21. How Can I Put Meta_Compare in the Database-Query?
  22. How to paginate information obtained from a query to a custom table?
  23. Historic WordPress database connection
  24. Check if an option exists and get its value in one hit
  25. Query multiple tables at once?
  26. $wpdb->query can’t insert data
  27. Custom WordPress Table wpdb
  28. Best practice to limit results in get_row()?
  29. How to display content from external db with relevant urls
  30. Connecting to a different database
  31. SQL query to set posts in bulk based on the post content
  32. Query Column of Specific ID from Database Table
  33. Custom search query by category id
  34. How to display data from db in select list [closed]
  35. How can I query the db to access current post information?
  36. Compare User meta_value with Product meta_value
  37. How to insert a value to decimal type field using wpdb->prepare?
  38. Join Query on WP_USERMETA Table
  39. Insert NULL value using prepare()
  40. Job and Employee Performance Tracking with Product Safety
  41. WordPress Database Query works in phpMyAdmin but not in the code
  42. wpdb query to insert images in to post/page gallery
  43. Set SQL_BIG_SELECTS and MAX_JOIN_SIZE on a WP_Query
  44. Performance bug – slow DB query
  45. How to optimise this database query?
  46. How can we speed up wp_get_nav_menu_items()?
  47. Extracted CSV as Array for Custom Query Loop
  48. Should I Use only wpdb Class to Write Custom Queries?
  49. Generating an HTML table from an array based on dynamic key values
  50. Pulling values from a sepcific row in table
  51. Using class id from array for query
  52. database search feature
  53. SQL Query to get post_id from wp_posts and and meta_key(s) from wp_postmeta
  54. SQL query to rewrite all media URLs to end with .webp
  55. How do I find users by password?
  56. Exclude Statement in SQL
  57. Can a post ID be 0?
  58. Issue with wp_insert_post and post_content field error Could not update post in the database
  59. wp_posts – guid update
  60. what is the wp_5_posts table in the database?
  61. Migrating data between local and development server
  62. WordPress Database Charset/Collate
  63. What is the database table for pages?
  64. Using Dynamic Data Pulled from a MySQL Table in a WordPress Page
  65. Is database safe after merging a branch of a more recent version over an older one?
  66. Hook to be used when creating a database table
  67. Delete all post meta except featured image
  68. Where is custom template file chosen for a post stored in the DB?
  69. Safe way to find last inserted id in a table?
  70. Is it possible to split database tables using HyperDB?
  71. Show content from database
  72. “Error establishing a database” connection on some sites
  73. change wp user status from wp_users table
  74. Is MariaDB’s Aria storage engine suitable for WordPress?
  75. Difficulty importing my live site to local
  76. WordPress running SQL query to update database from form
  77. How to fix database error duplicate entry
  78. WPDB SQL query with prepare() returning variable, not db value
  79. Get value form wordpress database
  80. Why this query is not showing any result on wordpresss home page?
  81. Is there an easy way of exporting posts with their category already asigned and pictures from localhost?
  82. Connect to another WP install and grab post based on custom field
  83. Adding prefix to WordPress database tables breaks admin capabilities?
  84. What is the best way to resurrect and update my old WordPress site?
  85. content disappearing minutes after it’s published
  86. What is the most efficient way to reset a WordPress site?
  87. Add pdf to a website
  88. Optimizing function that automatically creates internal links based on post title string
  89. Can two domains use the same database?
  90. _wp_attachment_metadata is not being added to database when PDF files uploaded
  91. adding user_id and name to a separate table whenever a user register based on role
  92. How do I loop/iterate through posts to edit all img tags?
  93. How to edit posts/pages without making the change live?
  94. How to retrieve user data based on role using SQL?
  95. Adding featured for post using database
  96. Store id from database query in cookie
  97. Split database on large site?
  98. Store the wordpress “featured image” under »wp_posts« Database table
  99. What WordPress file is saving new users to database
  100. wordpress database error
tech