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 to fix pagination for custom loops?
  7. Jquery Slider for profile template
  8. Counting the posts of a custom WordPress loop (WP_Query)?
  9. if ( is_home() && ! is_front_page() )
  10. Get excerpt using get_the_excerpt outside a loop
  11. How to display Yoast SEO meta description in archive template for each post instead of the_excerpt()? [closed]
  12. Get post content from outside the loop
  13. Why should I put if(have_posts()), is while(have_posts()) not enough?
  14. Display featured products through custom loop in woocommerce on template page
  15. Split Content and Gallery
  16. How to get Author ID outside the loop
  17. How can i display the content in plaintext
  18. Redirect loop when trying to login to /wp-admin/ [duplicate]
  19. How to split a loop into multiple columns
  20. Is it necessary to reset the query after using get_posts()?
  21. Is there any difference between the_title() and echo get_the_title()?
  22. AJAX with loop filtering categories
  23. Do I need to use The Loop on pages?
  24. Remove the Homepage Query
  25. remove tags from the_content
  26. the_title() shows title of the first post instead of the page title?
  27. How to force excerpts / teasers in the loop
  28. Retrieve each widget separately from a sidebar
  29. Why am I being limited to ten posts on a custom loop?
  30. Should I use loop in the single.php file?
  31. A search for ‘0’ returns results
  32. Why do themes rely on “The Loop”?
  33. How to return loop contents
  34. Using the Loop to show all levels of subpages under a parent page? Halfway there
  35. Cleanest Way to Select Every Second Element in a Loop?
  36. Insert image or ad script after 3 posts using the loop
  37. Get date of last update outside of loop
  38. Pagination not working on home page
  39. Child Pages Loop
  40. How to place comments_template(); outside the loop?
  41. Multiple Loops Homepage?
  42. How to Change Loop to Order Posts by Views (using wp-postviews plugin)
  43. how to upload image using wp_handle_upload
  44. Avoiding using a loop to access a single post
  45. How to get the first image gallery of a product in woocommerce in a loop
  46. Get post by page name or slug
  47. save_post + insert_post = infinite loop
  48. Loop.php vs looping inside template file
  49. Get ID of a page containing secondary loop in content
  50. Custom Loop and Infinite Scroll
  51. Loop that displays PARENT PAGE & CHILD PAGE & outputs GRANDCHILD PAGE title and content
  52. is_home, and is_front_page conditional problem
  53. Is `query_posts` really slower than secondary query?
  54. Are there any scenarios where the query_posts may be used?
  55. the_content and wp_link_pages
  56. Adding ‘current_post_item’ class to current post in the loop
  57. How do I get the attributes of a short code from a post?
  58. How can I custom order the results from wp_list_categories?
  59. ACF Repeater loops and resets – where is the reset_rows() documentation? [closed]
  60. WooCommerce Product Page Loop – Output All Product Thumbnails
  61. wp-admin redirecting to https, denying login
  62. Endless loop with wp_insert_post and wp_update_post
  63. Display subpages under parent page as a list within a loop
  64. Why is it necessary to call rewind_posts() when using the loop more than once? [duplicate]
  65. When to use wp_reset_postdata();
  66. Is including the loop necessary for page.php? [duplicate]
  67. the_title(); works in a page template, outside the loop. Why?
  68. wordpress loop for specific category
  69. Add 20yrs to post date, and then query
  70. Why do themes have `while( have_posts() )` in templates like single.php?
  71. When and Why is is_singular(‘my_cpt’) true while in_the_loop() is false?
  72. Three different post types on homepage
  73. What is best way passing variables to theme templates and using them different places like widgets?
  74. Apply styling only to first page sticky posts
  75. WordPress category & taxonomy loop with pagination
  76. Add Incrementing ID to each paragraph in the_content
  77. Changing behavior of the loop twice in one page
  78. How do I prevent one of two multiple loops from repeating on a second page?
  79. Insert/sticky specific post into Loop at specific location
  80. Style every four posts differently [duplicate]
  81. Return vs Echo Shortcode
  82. wp_list_categories: get latest featured_image of category
  83. Hook into the loop via a plugin, and output something after every X post?
  84. Multiple posts with one loop iteration
  85. Two custom loops, pagination, offset
  86. Identify the page being shown while in The Loop
  87. WordPress Alphabetical Glossary close div in loop
  88. Query date in wordpress loop
  89. How to find meta_values to call
  90. Alternate loop output every three posts (within the same original loop)
  91. Show newly added posts since last user login time /date
  92. Show scheduled posts in archive page
  93. Use the_content outside the loop
  94. What exactly defines a Main Loop and a Secondary Loop?
  95. Loop code is displaying pages but not actual posts
  96. Transient not working for custom loops
  97. Where should I use post_class()?
  98. How are both HTTP and HTTPS versions displaying?
  99. Custom Loop, Match Category with Page
  100. Display all authors and their only one latest post
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)