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:
- Using wpdb to connect to a separate database
- WPDB Insert or if exists Update
- get_results using wpdb
- What’s the simplest way to backup my WordPress database?
- $wpdb won’t insert NULL into table column
- Get error messages when $wpdb->insert() returns false?
- Detecting errors generated by $wpdb->get_results()
- Does dbDelta delete columns as well?
- wpdb update add current timestamp not working
- How to fetch Data in WordPress using MySQLi or $wpdb
- wpdb->insert multiple record at once
- WordPress Unit Testing – Cannot Create Tables
- How to define composite keys with dbDelta()
- Why does $wpdb return strings for mysql integer values?
- $wpdb->prepare() warning in WordPress 3.5
- Inserting data into custom tables
- Hook into $wpdb
- Display data from a non wordpress database on a page template
- How does $wpdb handle COUNT(*)
- How might I retrieve a featured post image from an external WP site and display it as a link back?
- WordPress database error: [Query was empty] [closed]
- Export wordpress table to excel
- How to close wpdb connection? [duplicate]
- Inserting Post Meta From SQL
- Why does dbDelta() not catch MysqlErrors?
- Connecting to external oracle database
- Faulty restore of the database, encoding issue
- Can’t save ajax value to database
- What causes the “max_user_connections” warning on WordPress frontend?
- $wpdb variable throw this error Call to a member function get_results() on a non-object in
- Updating all rows of table with $wpdb
- Safe way to find last inserted id in a table?
- How to execute mulitple statement SQL queries using $wpdb->query?
- Is $wpdb->prepare escaping to much? How to use it properly?
- Database slowdown after update to 3.4.1
- When and why should I use $wpdb different return types?
- WordPress and automated MySQL backups to a different host
- How wordpress accesses its own database
- Remove database entries where post_date > expiration date
- Error connecting to DB in /wp-includes/wp-db.php on line 1538 [closed]
- Backup another database with BackUpWordPress plugin [closed]
- Why are no posts showing despite my apparently correct DB restoration?
- How to query the WordPress database to get posts of a certain custom post type, taxonomy and field?
- Get data from database using $WPDB
- How to use a different database to list and manage comments in the backend
- Getting all the users who have author privilege
- Multiple postmeta with same name for one post in wp_postmeta table
- WP Database Table to CSV file
- Cannot update custom database table row
- wpdb_prepare with multiple or condition
- For WordPress is there content in the database which I can safely ignore?
- Show last modified date of database
- $wpdb->insert is not working
- What happens if I overwrite the current wp_options table with a backup from a week ago?
- Extracting the post_id via the wp_insert_post action (external db query)
- WordPress database error – Error in SQL syntax – I can’t identify any error?
- In what part of the WordPress core does the users table and usermeta table get joined?
- Modify Database in Multi-Site wp_usermeta table
- Multiple wp_options tables to share content across installs
- Advanced SELECT query with condtional statements
- $wpdb doesn’t like to store arrays
- Select two sums with single get_var statement
- WordPress choose wrong database
- Redirecting to old domain after migration website
- Why does importing copies of the database dump and the document root make WordPress data inconsistent?
- Create table from array with prepare
- Update from 4.5 to 4.6 failing
- Does WordPress $wpdb functions wait when table is locked?
- Store partial database to an archive database time to time
- How Can I Put Meta_Compare in the Database-Query?
- WordPress running SQL query to update database from form
- $wpdb->insert Giving duplicates
- I’m not able to get access to $wpdb [duplicate]
- WPDB SQL query with prepare() returning variable, not db value
- $wpdb error (Call to a member function insert() on a non-object)
- Where is phpMyAdmin inside WordPress?
- Have working sql query… trying to adjust it to use $wpdb
- Is it important to have integers inserted using %d rather than %s?
- How To Run A Temporary Instance Of a WordPress Backup Without a Database?
- How to backup my site and restore my wordpress site
- Cannot restore wordpress database from sql dump [closed]
- Problem in using wpdb
- $wpdb->query can’t insert data
- Custom WordPress Table wpdb
- How to fetch records from database WordPress
- Best practice to limit results in get_row()?
- wordpress database restore – broken link
- restore a db after bad backup
- Best practice to import user base (subscribers) from one website to another?
- AJAX wp-mysql running too slow
- CreateOrUpdate in WordPress
- Problem migrating to localhost
- Clear Terms from Taxonomy for Specific Post IDs?
- Trouble running $wpdb->query() with last_insert_id
- How to get a list of WordPress default database tables?
- Connecting to a different database
- Using $wpdb | checking entered email against existing emails in db
- Query Column of Specific ID from Database Table
- How to delete a particular row in a database table
- How to create more than one new wpdb object?