Use Loop or direct database query?

In general I try to avoid custom SQL queries as much as i can and use the native WordPress functions but in some cases its much better/faster to use custom queries.

if the case is just get a list of posts the you can use the WP_Query or get_posts which will work almost as fast as a custom query (as long as you don’t need some advan

Related Posts:

  1. How to iterate through database until it find a match
  2. How do I order my loop query?
  3. Generating a perfect loop
  4. wpdb inside foreach loop only returns first result – 2 other similar cases found [closed]
  5. Exclude Posts Using Meta Query and User Meta
  6. How do I get the attributes of a short code from a post?
  7. WordPress category & taxonomy loop with pagination
  8. Changing behavior of the loop twice in one page
  9. Show scheduled posts in archive page
  10. post__in – Placing content from a foreach loop inside of an array
  11. loop query exclude meta_key with meta_value
  12. “Blog pages show at most” in The Loop
  13. wp_insert_posts Fatal error: Maximum function nesting level of ‘100’ reached, aborting!
  14. Post Loop not Returning Permalink
  15. Displaying child page content of a certain parent
  16. Pagination adding extra posts only on page 2
  17. add_filter() doesn’t work in loop
  18. The Loop in Static Page
  19. Content/Excerpt length control for a specific loop?
  20. Why we use if with while loop?
  21. Loop posts only excluding first post
  22. Loop repeating design pattern
  23. Sort Posts By Category?
  24. Can’t access login screen, wp-login.php 404’s
  25. Customize WooCommerce Product Images (Placement and size) [closed]
  26. Create a loop that gets pages with their template
  27. Why is my loop not dynamically grabbing the correct Category and displaying all categorized posts?
  28. How to check if a post exist?
  29. Query posts if meta key starts with
  30. 3 Posts in Loop, Show Stickies First
  31. Loop within a loop (Again) for template
  32. How to use current_post to open a new unordered list every five posts
  33. Why cant you place the Loop outside of the index.php?
  34. sticky post in custom loop
  35. Rating system and changing the loop
  36. Ajax Button to load more Posts into a timeline
  37. How to target thumbnails of the first post in the loop
  38. On single.php, fetch 2 posts created after and 2 posts created before in relation to the actual post (using menu_order)
  39. Problem getting current post tags to show in a widget
  40. Exclude page name from loop
  41. PHP if post is already displayed, then
  42. How to style first post differently with ‘get_template_part’?
  43. Include multiple page ids in loop
  44. in Foreach Loop the Description is not showing?
  45. 404 Template customization | Want 10 recent Post on the 404.php error page apart from the error Notice
  46. How to append a query string to pagination?
  47. For each loop on every word in post
  48. Display name of taxonomy once
  49. Use have_comments() for current post instead of last post in loop
  50. Displaying the first, second, and third posts from a category in separate slides
  51. WordPress shortcode in content, output in sidebar?
  52. Using variable in WordPress loop as criteria
  53. WordPress Alphabetical Sort Loop Issue
  54. Call wp-blog-header.php header without performing a wp_query
  55. Display post formats differently on index.php (loop in function)
  56. Get_template_part() problem with the_content()
  57. How to output thumbnail twice in a loop
  58. Fetching posts from wordpress function in ajax
  59. Saving return value from the_author_posts_link()
  60. Display more than 10 posts on author.php file
  61. how to run loop in function.php that sends email based on specific conditions?
  62. How to use this $tax_selection variable in this custom loop?
  63. Display all categories as plain text
  64. How to sort a loop after most viewed
  65. How to display fields from the loop in two separate divs
  66. WordPress posts loop not displaying all posts on blog
  67. get_page_by_title not working inside fucntions.php
  68. Bootstrap tabs are not being clicked in WordPress loop
  69. Get gallery in loop through ajax
  70. Get a specific size from wp_get_attachment_image_src
  71. Pagination on a underscore custom theme
  72. Build a Page which shows the Oldest Post with specific Custom Field Value
  73. WordPress multiple loops with default pagination
  74. Get top Page IDs from menu and cycle through their child pages on a scroller
  75. Show other category posts in single.php
  76. Why does it loop twice?
  77. Style first 3 posts differently and use a 2nd loop to get rest of posts / offset and pagination broken
  78. Posts Per Page is Not Returning Correct Number
  79. Custom Looping of WordPress Posts
  80. how to place Post and page content side by side
  81. Add specific class to featured posts
  82. Echo Most Recent Sticky Post in Loop?
  83. ACF field not appearing correctly in loop
  84. Posts are being displayed from old to new, in ascending order
  85. Loop in taxonomy for terms and post
  86. WordPress Tags in class
  87. Display articles related to a custom field on a page
  88. The Loop isn’t working
  89. Changing the loop w/o killing category links
  90. Custom loop page with post navigation
  91. Pages with a loop (index, archive) are loading the first image as post_thumbnail
  92. the loop – how to control whether wp or plug-in runs it
  93. stuck with template hierarchy
  94. How to create an identical second loop for attachments?
  95. Loop from another WP site onto mine
  96. Having issue with WordPress loop
  97. Wrap every 2 divs in row – for each loop [closed]
  98. How to add class to the last image of the last post in a loop
  99. Divide loop into several columns based on post custom field and enable infinite scrolling
  100. Query Loop Block: possible to restrict just child pages?