I can’t comment on foreign keys but moving to InnoDB would be a good idea for large scale. Although it’s a little slower than MyISAM, it does row level locking, rather than table level locking. As a result saving a post or doing a lengthy operation or query won’t lock the posts table, freezing the … Read more
The parent column is the term_id of a parent term
If you just add p: then it conflicts with MySQL Port. So wp-config.php file you should be able to do it by replacing define(‘DB_HOST’,’localhost’); with define(‘DB_HOST’,’p:localhost:3306′);
This is what I’ve found. I’m using a filter to filter the ORDER BY on the SQL query generated by WP_Query. The filter is this posts_orderby. And with it, you can write a custom ORDER BY for the query. I’m gonna show you an example. add_filter(‘posts_orderby’, ‘posts_orderby’); function posts_orderby($orderby_for_query) { $orderby_for_query = “LEFT(wp_posts.post_date, 10) DESC, … Read more
As the article mentions, using wp_options is not a good idea when you have thousands of terms, mainly because there’s: a lot of serialization involved OR long option names (the limit is 64 characters) In this particular case, yes, it’s appropriate to create some custom tables. To save time, you can use this plugin (update … Read more
Double-check your SQL syntax. It sounds like you want to do a JOIN … But you’re not building the query correctly. It should be something more like: SELECT u.ID, u.user_login, u.user_nicename, u.user_email FROM $wpdb->users u INNER JOIN $wpdb->usermeta m ON m.user_id = u.ID WHERE m.meta_key = ‘wp_capabilities’ AND m.meta_value LIKE ‘%supplier%’ ORDER BY u.user_registered You … Read more
Add flush_rewrite_rules(); to your theme’s functions.php, load the page, and them remove it. It is very inefficient to have that run on every page load. Hopefully your edits to the options table are sane. If not, that will not work. Caveat: I think that functions.php is adequate. You may need to add it to a … Read more
In the question you linked to, the solution was to use mysqli_multi_query as the API for executing the SQL. $wpdb desen’t have an API to do a multi query therefor you can’t use it directly, but you can get the handle to the mysql interface from $wpdb->dbh and do something like $sql_trigger = “….”; mysqli_multi_query($wpdb->dbh,$sql_trigger);
You are facing an XY Problem. The only reason to save meta values each as a single row, would be if you need them to be searchable. If you need specific sanitization rules, use either filter_var_array() or sanitize the values, then build the array and finally save the value. Gist with a comprehensive filter_var_array() example … Read more
Category images are stored as attachments, which is a post type. You’ll find them in wp_posts with a post_type “attachment”. The guid field contains the location of the image.