Profiles

Posted a reply to A Game-Changer for Database Efficiency, on the site WordPress.org Forums:
Yes, that is the offending query pattern addressed by the plugin I mentioned.

Posted a reply to A Game-Changer for Database Efficiency, on the site WordPress.org Forums:
Thanks for the kind words, Maxime Michaud. For your store with hundreds of thousands of…

Posted a reply to Can it deactivate?, on the site WordPress.org Forums:
Thanks for your question. I guess you want to know whether you can add the…

Posted a reply to Will “Index WP MySQL For Speed” Stay Robust in Future Updates?, on the site WordPress.org Forums:
Thanks for your questions, Maxime Michaud. There will come a time, I hope, when MySQL…

Posted a reply to cant convert keys on _postmeta & _posts, on the site WordPress.org Forums:
Sorry to say, I don't see any upload with that ID. Try again?

Posted a reply to Critical Error when trying to enable postmeta, on the site WordPress.org Forums:
It looks like the "OPTIMIZE TABLE" didn't work to repair that table. Here's a possible…

Posted a reply to Duplicate key name meta_value, on the site WordPress.org Forums:
It looks to me like you, or someone, has done quite a bit of work…

Posted a reply to leave installed or run once, on the site WordPress.org Forums:
It's best to leave this plugin activated, because WordPress core updates try to restore the…

Posted a reply to Author select boxes aren’t working properly with plugin enabled., on the site WordPress.org Forums:
Thanks for the problem report. There are four different author selection boxes with four different…

Posted a reply to Caching Compatibility with AffiliateWP Plugin, on the site WordPress.org Forums:
"Varnish or redis" ? That's a confusing statement in the AffiliateWP documentation. Varnish is a…

Posted a reply to Slower looks up with meta_id sort from update_meta_cache, on the site WordPress.org Forums:
Thanks for the question. Some versions of MySQL / MariaDB perform the IN (long, list,…

Posted a reply to Missing data after deactivation, on the site WordPress.org Forums:
If you deactivated the cache, the contents of the cache are removed from your system.…

Posted a reply to backend takes 10+ seconds, on the site WordPress.org Forums:
Thanks for the upload., I only see one query that's particularly slow, it has to…

Posted a reply to Duplicate key name meta_value, on the site WordPress.org Forums:
Thanks for the question and the upload. Something is set up strangely in your database…

Posted a reply to Database too big., on the site WordPress.org Forums:
Thanks for the upload. That is indeed a surprising amount of database size growth for…

Posted a reply to programatically disable sqlite object cache, on the site WordPress.org Forums:
Thanks for this information. If you need more help please start another topic.

Posted a reply to Search By Name, Email not working, on the site WordPress.org Forums:
Recent versions of this plugin should have corrected the defect you showed me. If you…

Posted a reply to cant convert keys on _postmeta & _posts, on the site WordPress.org Forums:
I'm happy to hear you sorted out your first problem. And, for me to help…

Posted a reply to Critical Error when trying to enable postmeta, on the site WordPress.org Forums:
Sorry you're having trouble. Try this wp-cli command. wp db query "OPTIMIZE TABLE G03_postmeta" If…

Posted a reply to Unable to read published form data (Lost connection to MySQL server during query, on the site WordPress.org Forums:
Thanks for the upload. I see nothing particularly wrong with your MySQL server configuration. Try…

Posted a reply to This plugin vs custom table – question regarding performance, on the site WordPress.org Forums:
Good question, thanks! tl;dr Correct, this plugin doesn't work with custom tables. Query performance of…

Posted a reply to Unable to read published form data (Lost connection to MySQL server during query, on the site WordPress.org Forums:
This generally means your MySQL (or MariaDB) server software crashed. I've only seen this happen…

Posted a reply to slow backend, on the site WordPress.org Forums:
I haven't seen any followup in a month so I am closing this topic. Please…

Posted a reply to How to use this plugin?, on the site WordPress.org Forums:
I don't see anything super-obvious; your site has a little more than 8K posts, and…

Posted a reply to How to use this plugin?, on the site WordPress.org Forums:
Thanks for the question. Please read this: https://wordpress.org/support/topic/please-when-you-report-a-problem-or-ask-for-help/ It offers instructions on how to get…

Posted a reply to 4.3GB table size but still slowness, on the site WordPress.org Forums:
The latest version of this plugin, https://wordpress.org/plugins/fast-woo-order-lookup/, contains a cache to handle the offending query.…

Posted a reply to Help with customized WooCommerce site, on the site WordPress.org Forums:
You probably should use wpcli to do the reindexing on a large site; it could…

Posted a reply to Search By Name, Email not working, on the site WordPress.org Forums:
Thanks for the defect report. I've been trying to track this down without success so…

Posted a reply to This plugin is a game changer for WooCommerce!, on the site WordPress.org Forums:
Thanks for the kind words! I'll take a look at the 100% problem you mention.…

Posted a reply to Help with customized WooCommerce site, on the site WordPress.org Forums:
Thanks for the question. Maintaining the keys on database tables is a routine operation on…

Posted a reply to Background user index building in progress: 31% complete., on the site WordPress.org Forums:
Thanks for the report, and thanks for your patience. Try deactivating and reactivating the plugin.…

Posted a reply to Process seems to be stuck, on the site WordPress.org Forums:
Thanks for the defect report, and for letting me know the problem cleared up. For…

Posted a reply to Can’t search by order number, on the site WordPress.org Forums:
The latest version of the plugin, 1.0.1, has in it a cache for the slow…

Posted a reply to Can’t search by order number, on the site WordPress.org Forums:
This problem is corrected in version 1.0.1. That version also adds a cache for the…

Posted a reply to programatically disable sqlite object cache, on the site WordPress.org Forums:
https://github.com/OllieJones/sqlite-object-cache/blob/1e192c4872ed90e5f2d9e9aa0bde71319edfaaa9/assets/drop-in/object-cache.php#L1441C1-L1446C1 Yes, that should work. I haven't tested it. It has to be said, disabling…

Posted a reply to Very useful, on the site WordPress.org Forums:
I'm glad to know you found it easy to use! Simplifying things without oversimplifying them…

Posted a reply to Simple, fast and effective, on the site WordPress.org Forums:
Ah, thanks especially for the Elementor feedback! I'm considering adding "if you use a builder"…

Posted a reply to Perfect solution for large database, on the site WordPress.org Forums:
Thanks for the kind words. Yes, Leho has it right about backward compatibility. A mess,…

Posted a reply to Help Improving Speed, on the site WordPress.org Forums:
Thanks for the uploads. You have not added the high-performance keys offered by this plugin.…