Use mysql_query instead of $wpdb query

Simple and short:

  • mysql_query() = Faster!
  • $wpdb->get_results() = Safer!

But in most cases since $wpdb is a global object and already in the memory using it will be be as fast as mysql_query().

Will this affect my performance?

It can affect for better performance changes but they would be minor changes that its just not worth it.

Related Posts:

  1. Differences between wpdb->get_results() and wpdb->query()
  2. How to Use Wildcards in $wpdb Queries Using $wpdb->get_results & $wpdb->prepare?
  3. wpdb get posts by taxonomy SQL
  4. Multipart/formatted MySQL query problem
  5. Custom $wpdb Query for Custom Post Type by Category
  6. Can’t pass table to $wpdb->prepare
  7. $wpdb->get_var not returning a result
  8. Most effective use of DB querys
  9. $wpdb->query() vs. $wpdb->get_results() vs. phpMyAdmin
  10. wpdb::prepare() isn’t working
  11. $wpdb doesn’t appear to work on page inside of a plugin
  12. Strange string in console from wpdb query
  13. Using $wpdb->update but confused on the WHERE in and SET
  14. What’s wrong with my $wpdb prepare?
  15. Make one query for adding entries to database
  16. How to execute a SQL-query which contains multiple queries using $wpdb->query?
  17. Alter a specific query on WordPress
  18. wpdb->term_taxonomy count posts from both published and private posts?
  19. wpdb print all post meta
  20. Plugin will sort users by usermeta
  21. wpdb query problem to access previous 3 days posts
  22. How to write: $wpdb->update having WHERE NOT value pair in the array
  23. I can’t figure out what’s wrong with this statement. $wpdb->query update
  24. wpdb COALESCE won’t work
  25. Custom Query – Based on user input
  26. Custom SQL Query passing array to WHERE p.id
  27. Get posts from category with custom query
  28. Custom Query returns array, but I can’t see it’s elements
  29. Valid SQL query return empty
  30. mysql query – how to escape apostrophe?
  31. $wpdb->prepare affecting the query?
  32. prepare function sql safe method
  33. Updating with $qpdb->query() always returns 0 rows affected
  34. How to return count of custom post type posts with a specific custom field value via $wpdb?
  35. WordPress Mysql query and Duplicate
  36. How do I query for posts by custom meta and those that have been stickied?
  37. Help with Related Posts Function
  38. wpdb update multiple row?
  39. Formatting a date/time returned from a custom $wpdb query
  40. Improve performance of slow query
  41. How do I get specific readable results from this query and array results
  42. implementing my wp_query using $wpdb class
  43. Exclude Posts from a Widget
  44. Fastest and most efficient SQL query to check if UID exists
  45. Use $wpdb->get_results with filter based on array
  46. $wpdb query for price in custom field value
  47. Display result from custom post meta query
  48. Wpdb empty result only if language is Russian
  49. Run an update query in a function
  50. How to fix this insert? Don’t work for me!
  51. Problem on wpdb queries, wp_insert_post, wp_insert_user etc. The query runs twice
  52. Update vs Insert logic but the last key is always inserted?
  53. There is way to improve this query? wordpress get post data and some meta data
  54. $wpdb: how to use a query as a base for another query?
  55. Wpdb generates too many queries
  56. Custom Query for searching through custom fields
  57. Mysql query and odd results
  58. How to reference same column name but different table in custom db query
  59. Retrieving custom field array value through db query
  60. How to get one result using wpdb class?
  61. Delete query won’t run
  62. update $wpdb one query
  63. get_results using wpdb
  64. Get all image from single page using this query
  65. Add multiple value to a query variable in WordPress
  66. wp_dropdown_categories with multiple select
  67. get post id using the $query_vars variable
  68. Is there a conditional tag for latest post or do i need a query?
  69. get_posts() loop returns the same the_title() for each post
  70. Temporarily storing main search result
  71. convert custom query to wp_query
  72. Select two sums with single get_var statement
  73. Help with MySQL to $WPDB query
  74. sql select query in wordpress ‘page’ [closed]
  75. Group custom post listing in admin section
  76. problem with sql query in wordpress plugin
  77. Using $wpdb (WPDB class) ‘replace’ with multiple WHERE criteria problem
  78. Searching With Apostrophe
  79. plugin code is pulling information from database in one instance and not in other. What is wrong?
  80. List author’s posts with SQL
  81. Where is the query in wp-login.php
  82. Order posts by recent comments
  83. query if page has not child
  84. What is wrong with my wp query, cant exclude the category that i want
  85. how to replace old DW site with new WP site? [closed]
  86. Order terms by count – missing terms
  87. Querying Advanced Custom Fields
  88. How to rearrange a pool of posts joined using two queries?
  89. Can I include get_posts in this array?
  90. Custom query Custom-Post-Types creates error
  91. Rewrite rule for query params
  92. Hook into the Admin Dashboard and redirect users
  93. Doing $wpdb->get_results returns NULL, doing the same query in my DB returns correct value
  94. Displaying data from custom table
  95. SEO friendly query vars
  96. Prevent versioning for .woff (font) files
  97. Orderby event date (if it exists) or post date (if it doesn’t) – how to reorder posts based on meta value OR date
  98. OR condition not working
  99. Query not returning child posts for any parent post ID
  100. SQL Query : how copy all tags of post into their post content in wordpress by sql query