that is a good solution, also woocommerce has plugins to create and move the products to custom table. this means instead a new database there is tables just for the products. also very efficient
Related Posts:
- WordPress database scalability from the code perspective
- Performance tips for a large user base [closed]
- WP_Options ID high
- WordPress for a very large website
- WordPress database becoming huge. How to analyze and optimize it? fear of running out of memory
- Improve or optimize a very slow query
- WooCommerce with thousands of products – site is very slow – optimize db queries? [closed]
- Efficiency on displaying random authors based on large database
- How to solve slow WordPress site caused by attachment_metadata
- Relationship between performance and database size
- Database slowdown after update to 3.4.1
- wp_redirection_404 table has grown to 7GB
- Which is more efficient? Using usermeta, or creating a new MySQL table?
- One post carries 30 postmeta values, is this too much?
- Multiple wp_options tables to share content across installs
- Improve performance by removing unnecessary database queries
- fastest replacement DB
- How to prevent/delay MySQL connections when an object cache is used?
- Does auto_load to ‘no’ in wp_options improve performance
- How to combine multiple wp_insert_post into one in order to gain better performance
- Optimizing function that automatically creates internal links based on post title string
- Job and Employee Performance Tracking with Product Safety
- What structure and database storage method should I use for temporary storage that may be written concurrently?
- Get all top categories, then only 3 posts for each
- Best way to store 1 billion+ posts?
- Optimize WP site for millions of posts
- Counting user’s comments – efficient way?
- Performance bug – slow DB query
- Mysql Queries per Visit – Crazy High
- How to resolve ORA-011033: ORACLE initialization or shutdown in progress
- Oracle SQL query for Date format
- Failed to connect to mysql at 127.0.0.1:3306 with user root access denied for user ‘root’@’localhost'(using password:YES)
- Can I have multiple primary keys in a single table?
- Using wpdb to connect to a separate database
- Database connection close
- How to stop WordPress using utf8mb4_unicode_520_ci collation?
- How to create bulk page and content? [closed]
- Importing posts from old website to new conflicting post ID’s?
- Exporting revisions
- How to use multiple database in wordpress?
- Is removing orphaned wp_postmeta records safe?
- What ALL can cause “Another update is currently in progress.”? [closed]
- Error connecting to DB in /wp-includes/wp-db.php on line 1538 [closed]
- Set Display Name to first and last name (phpmyadmin SQL Query)
- Trigger Plugin database update after git pull
- 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?
- Cannot update custom database table row
- SQL Error wp_commentmeta – incorrect table definition
- Change WordPress prefix for only one table?
- Two websites one database, administrator not working on second website
- Select two sums with single get_var statement
- How to get the SQL of the changes made to the database from an update or upgrade?
- Merging two wp_posts tables while avoiding duplicates
- How can i add custom fields into the contact form 7 [closed]
- Store partial database to an archive database time to time
- Move out of sync posts from one database to another
- MS Access to manage WordPress Database
- Migration: Copying database content to a different server
- Remove empty rows from the database
- Custom WordPress Table wpdb
- Check if post id exist in table than only update instead of inserting new row
- Detail explanation of wordpress database fields and metatag list [closed]
- Plugin has added weird data in wp_options, set to autoload
- CreateOrUpdate in WordPress
- $wpdb->get_results($wpdb->prepare(… You have an error in your SQL syntax;
- How to get a list of WordPress default database tables?
- Can local WordPress installs share /wp-content/ folder and database?
- Stringing together content from different databases
- Backing up WordPress database and files
- Safely store code(html/js..) into database
- Creating and Using Tables in the WordPress Database
- Connect a membership plugin to an external database
- Compare User meta_value with Product meta_value
- Storing user’s data on external database on other server
- Whats the best practise on how to store json data from a custom settings page?
- Recovery – Restore Database after moving folder location locally
- Migrate Users From laravel to wordpress
- /wp-admin not accessible after migrating to local host (no plugin issue)
- how add more field to wp user and save it to database
- set_transient fails if the value has more than 60.000 characters
- How do I cleanup my database with data that is no longer being used?
- Malware in old website – how to migrate?
- Set SQL_BIG_SELECTS and MAX_JOIN_SIZE on a WP_Query
- How to optimize wp_option table?
- How to display $wpdb->insert_id; value on redirected page
- Database for JQuery Autocomplete field
- Create Tables in WordPress
- Catchable fatal error in formatting.php
- Wrong url for the images while using same database for two WordPress installations
- WordPress Failed to Login (DB Error)
- Sending WordPress database information to cross domain the safe way?
- Database Name Change
- Where To Find bb_profile_data(); In bbPress?
- ERROR: “Table Prefix” must not be empty
- How do you build a database-centric site in WP?
- Attach posts based on category and position
- wp_usermeta key problem
- Database Queries are crashing the server
- Uploading to WordPress Database