The Transient API saves data inside the database, which isn’t as effective as APC, but a similar workflow as used for transients can be used for APC. It is important to check if APC is available and active, so its functions are usable. Because this isn’t always the case, it is to consider to add … 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
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
If you don’t feel any performance degradation then there is no problem. If it took you two years to get to this state then you probably safe for another two years, which is almost forever in the time scale of the internet (unless you are CNN or similar). This doesn’t mean that you should not … 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.
The woocommerce membership plugin uses the post table to store it’s data, however pretty much all queries from the plugin will contain wc_membership in them (they use it in all of the post_types but it may not catch all the meta_query, will need testing, see if any error or missing data happens, find all the … Read more
Remove the call to $wpdb->prepare(): $result = $wpdb->get_var( “SELECT DISTINCT meta_value FROM $metatable WHERE meta_key LIKE ‘%matchme%’ AND meta_value IS NOT NULL AND meta_value <> ”” ); In this case, the $wpdb->prepare() function is not doing anything. There are no variables holding unknown values, therefore there is no need to sanitize them. If you did … Read more
As others have already mentioned, this can be a long process. But it can also be relatively straightforward, and I’ve done this to migrate other non-WP sites to WordPress in the past. Export your site First things first, you’ll need to export your site from Tumblr into a format WordPress can work with. There are … Read more
WordPress actually specifies no table type in the create statements, so it uses MySQL’s default table engine which is InnoDB from version 5.5 onwards.
The GUID should not be used to generate any URLs for the site (caveat below), so it shouldn’t hurt to leave them as they are… unless some badly designed plugin decides that GUIDs are a great shortcut to getting an URL. What the GUID is, is a globally unique identifier– global as in “throughout all … Read more