If the content is interconnected, and your content is as you have posts in both categories, you can’t split it without losing some of the capabilities that you have now (search will be one of them).
4.- Yes, improve your server settings or use more servers.
Related Posts:
- Undefined function mysql_connect()
- MySQL column count doesn’t match value count at row 1 [closed]
- Fatal error: Call to undefined function mysql_connect()
- the_date() not working
- How to return number of found rows from SELECT query
- Check if post of title already exists
- $wpdb->delete column values IN ARRAY()?
- How to make WordPress plugin check for database changes and then do something?
- Custom SQL query to get List of posts with featured image url
- Delete post revisions on post publish
- Problems migrating WordPress to localhost
- error importing localhost export file to server
- How to sort results from a custom database table
- Update some database fields when post is saved
- Successful or Error Message after running mysql code in functions.php
- sql query to put quotes around numbers in img tag
- No wp-config.php file on local install of wordpress – site still displays
- Use ajax to update_post_meta
- PHP/MySQL issues when running WP on EC2 cloud [closed]
- WordPress get pagination on wpdb get_results
- How to create another version of my site based on the same database
- Strange wordpress slowness
- Looking for most performant way to execute several similar WP queries within shortcodes
- Setting All Drafts to ‘exclude-from-catalog’ in WooCommerce
- Stumped on migration
- PHP code inside shortcodes
- Show MySQL errors that occur when I excute $wpdb->insert()
- Is XAMPP faster than running LAMP in WSL on Windows 10? [closed]
- WordPress Site Running Extremely Slow on Dedicated Server
- Create WP_Query to search for posts by their categories or their parent/child categories
- Get updated query results on page after insert in database
- WSoD being caused by this piece of code
- WordPress not reflecting changed of the database
- How can I fix WordPress installation errors?
- How to display data from custom table in wordpress phpmyadmin
- How to split links generated into an xml sitemap to avoid exceeding 30 sec maximum execution time?
- Hacked WordPress website /Homepage redirect [closed]
- get_posts() and WP_query limits ‘AND’ conditions to a maximum of 6 for meta value queries in WordPress
- Replacing mysql_escape_string in a custom plugin when moving to PHP7
- Refresh table data with Ajax
- Database query works fine outside WordPress
- Large Woocommerce Site (83,000 items), What Can I Do? [closed]
- Help with a $wpdb MySQL Query
- How i can obtain all the post meta for a specific post as an array?
- Grouping posts by a custom meta value
- Can’t Query Custom Table Using $wpdb Method
- $wpdb returns duplicate posts
- Update postmeta after theme switch
- Mixing variables into an array when inserting values
- Should I use WordPress to skin a database website?
- Creating Database Table vs. Adding MetaData to Post & User
- WordPress Custom SQL Table with UserID Filter for results
- How can I add a new row in a separate database when someone registers via WordPress?
- How to use mysql LIKE with wpdb?
- Submitting a form, using Ajax, to run a SQL Select query based on user input from the form
- WordPress WP_Query without query GET parameters
- How to use AJAX in WordPress in MYSQL query?
- Use variable in SQL statement
- Processing ajax call to php to insert into mysql database
- WPDB secure custom form
- phpMyAdmin error #1062 – Duplicate entry ‘1’ for key ‘PRIMARY’
- Query the links Database
- WordPress Custom Query: Combining Two Functions
- MySQL Query Returns Array () In Shortcode
- Passing in MySQL prepare statement parameter separately throwing error
- Convert a column of a table containing an Array as response in HTML
- Database SQL query error
- Error establishing a database connection (Set-up locally)
- Display Results of SQL Query on WP site
- PHP Warning: mysqli_query(): after updating my websites php from 5.6 to 7.2
- MYSQL TIMESTAMP when adding DATE_FORMAT then the output is blank, PHP conflict?
- Updated Php version from 5.4 to 7.2 and getting “PHP installation missing the MySQL extension needed by WordPress”
- How to optimize and reduce excessive database queries
- How to display MySQL table data which is stored as an array?
- Store GA Client ID in User DB
- How to import woocommerce custom fields data into another site?
- PHP 7.2.18 | Your PHP installation appears to be missing the MySQL extension which is required by WordPress
- Windows Setup: Error establishing a database connection
- Need help with format of nested array in MySQL
- WAMP SERVER Command Prompt SET PATH=%PATH%
- Inserting other fields to existing registration form in a WordPress theme
- Advanced WordPress SQL Query
- Splitting table data to pages with numbers
- Site doesnt work once PHP changed to 7.1
- How to detect if a revision was made by woocommerce or wordpress?
- WordPress WPDB::insert 13th param is always blank (only if format)
- Ajax not updating to database
- can’t delete a row from post_meta table
- MySQL query in WordPress with AJAX
- MySQL queries in WordPress
- retrieve wordpress post-meta using php not wordpress functions
- Splash pages on a high traffic site
- Predefine Magazine Style Layouts
- I am unable to fetch json data from wp_db
- Submit cf7 form to cfdb as pdf/BLOB [closed]
- How to send push notification in android using php? [closed]
- Getting invalid user ID error when creating a new user with wp_insert_user
- Custom form that stores data in mysql database
- Putting form result in my database
- How can I update a value of a field depending on outside source?