Does wpdb add considerable overhead on queries with large result sets?

There is a significant amount of memory usage if you use the $wpdb for queries that return very large result sets. $wpdb loads the entire results from any given query into memory. So if you’re, say, selecting all the posts, then it’ll try to load the whole thing into memory immediately.

So for something like a backup plugin, direct calls to mySQL with loops for retrieving the data make more sense.

Related Posts:

  1. Using wpdb to connect to a separate database
  2. WPDB Insert or if exists Update
  3. get_results using wpdb
  4. $wpdb won’t insert NULL into table column
  5. Get error messages when $wpdb->insert() returns false?
  6. Does dbDelta delete columns as well?
  7. How to fetch Data in WordPress using MySQLi or $wpdb
  8. wpdb->insert multiple record at once
  9. How to define composite keys with dbDelta()
  10. Why does $wpdb return strings for mysql integer values?
  11. $wpdb->prepare() warning in WordPress 3.5
  12. Inserting data into custom tables
  13. Hook into $wpdb
  14. Display data from a non wordpress database on a page template
  15. How does $wpdb handle COUNT(*)
  16. WordPress database error: [Query was empty] [closed]
  17. Inserting Post Meta From SQL
  18. Connecting to external oracle database
  19. Faulty restore of the database, encoding issue
  20. Can’t save ajax value to database
  21. What causes the “max_user_connections” warning on WordPress frontend?
  22. $wpdb variable throw this error Call to a member function get_results() on a non-object in
  23. Updating all rows of table with $wpdb
  24. How to execute mulitple statement SQL queries using $wpdb->query?
  25. Is $wpdb->prepare escaping to much? How to use it properly?
  26. When and why should I use $wpdb different return types?
  27. WordPress and automated MySQL backups to a different host
  28. How wordpress accesses its own database
  29. Remove database entries where post_date > expiration date
  30. Backup another database with BackUpWordPress plugin [closed]
  31. Get data from database using $WPDB
  32. How to use a different database to list and manage comments in the backend
  33. Getting all the users who have author privilege
  34. wpdb_prepare with multiple or condition
  35. For WordPress is there content in the database which I can safely ignore?
  36. Show last modified date of database
  37. $wpdb->insert is not working
  38. Extracting the post_id via the wp_insert_post action (external db query)
  39. In what part of the WordPress core does the users table and usermeta table get joined?
  40. WordPress choose wrong database
  41. Create table from array with prepare
  42. Update from 4.5 to 4.6 failing
  43. Does WordPress $wpdb functions wait when table is locked?
  44. $wpdb->insert Giving duplicates
  45. I’m not able to get access to $wpdb [duplicate]
  46. Where is phpMyAdmin inside WordPress?
  47. Have working sql query… trying to adjust it to use $wpdb
  48. How to backup my site and restore my wordpress site
  49. Cannot restore wordpress database from sql dump [closed]
  50. Problem in using wpdb
  51. $wpdb->query can’t insert data
  52. How to fetch records from database WordPress
  53. wordpress database restore – broken link
  54. restore a db after bad backup
  55. Best practice to import user base (subscribers) from one website to another?
  56. AJAX wp-mysql running too slow
  57. Problem migrating to localhost
  58. Clear Terms from Taxonomy for Specific Post IDs?
  59. Connecting to a different database
  60. Query Column of Specific ID from Database Table
  61. How to delete a particular row in a database table
  62. How to create more than one new wpdb object?
  63. Update multiple rows in one query
  64. How to connect and insert data in database of wordpress?
  65. Should I use an additional column in the DB?
  66. access JSON results from wordpress database with wpdb
  67. Getting value from database table depending on field value
  68. wpdb->insert not inserting first variable
  69. How do I have a user upload a blog post and then retrieve that to display in a card on the site?
  70. How to escape percentage sign(%) in sql query with $wpdb->prepare?
  71. wpdb Insert unknown post data dynamic foreach loop
  72. How do I get database rows from a custom table using wpdb?
  73. How can i restore a WordPress site with the DB and WordPress Files
  74. Help with $wpdb on custom code
  75. “BS_” rows in postmeta table
  76. How to rerieve comments and their replies from DB
  77. is it possible to install new WordPress in an old WordPress folder?
  78. Help posting values to DB on submit using $wpdb->query
  79. How to add download link from database on custom page template?
  80. 2 $wpdb queries causing error Table ‘wp_postmeta’ is specified twice, both as a target for ‘UPDATE’
  81. WPCLI search and replace in a particlar site dir effect another site-dir
  82. insert data from a form:: Warning Empty query mysqli::query()
  83. How can I get $wpdb to show MySQL warnings?
  84. About wp database hooks (error establishing connection)
  85. How to get specific table by current user login
  86. How do I find out from my database what version of WordPress I need?
  87. How To connect to the same WordPress database with different database user
  88. Accessing content from third party as native posts in WordPress
  89. Should I Use only wpdb Class to Write Custom Queries?
  90. Copy WordPress to new directory
  91. I have include wp-config, should I add global $wpdb also?
  92. Can’t Install WordPress (local) Failed to open file wp-includes/wp-db.php
  93. version control for wordpress? (wordpress folder and database at same time)
  94. using same mysql user with many databases
  95. Pulling values from a sepcific row in table
  96. Inserting into data into external DB using WPDB
  97. Insert Extra fields added in the front end registration form to DB
  98. $wpdb->insert not working for last select option
  99. What’s the cleanest way to transfer WordPress to a new server
  100. Uploading to WordPress Database

Leave a Comment