Title: sushantchawla2005's Replies | WordPress.org --- # sushantchawla2005 [ ](https://wordpress.org/support/users/sushantchawla2005/) * [Profile](https://wordpress.org/support/users/sushantchawla2005/) * [Topics Started](https://wordpress.org/support/users/sushantchawla2005/topics/) * [Replies Created](https://wordpress.org/support/users/sushantchawla2005/replies/) * [Reviews Written](https://wordpress.org/support/users/sushantchawla2005/reviews/) * [Topics Replied To](https://wordpress.org/support/users/sushantchawla2005/replied-to/) * [Engagements](https://wordpress.org/support/users/sushantchawla2005/engagements/) * [Favorites](https://wordpress.org/support/users/sushantchawla2005/favorites/) Search replies: ## Forum Replies Created Viewing 8 replies - 1 through 8 (of 8 total) * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Dokan: AI Powered WooCommerce Multivendor Marketplace Solution – Build Your Own Amazon, eBay, Etsy] Double Cache Purge Issue When Updating Products via Dokan REST API](https://wordpress.org/support/topic/double-cache-purge-issue-when-updating-products-via-dokan-rest-api/) * [sushantchawla2005](https://wordpress.org/support/users/sushantchawla2005/) * (@sushantchawla2005) * [1 month, 3 weeks ago](https://wordpress.org/support/topic/double-cache-purge-issue-when-updating-products-via-dokan-rest-api/#post-18822854) * Hi [@sazdhossain](https://profiles.wordpress.org/sazdhossain/) * Can you revert back on this urgent issue, please? * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[WP Offload Media Lite for Amazon S3, DigitalOcean Spaces, and Google Cloud Storage] Plugin causing lots of slow queries on heavy site due to wild cards](https://wordpress.org/support/topic/plugin-causing-lots-of-slow-queries-on-heavy-site-due-to-wild-cards/) * Thread Starter [sushantchawla2005](https://wordpress.org/support/users/sushantchawla2005/) * (@sushantchawla2005) * [7 months, 1 week ago](https://wordpress.org/support/topic/plugin-causing-lots-of-slow-queries-on-heavy-site-due-to-wild-cards/#post-18625332) * Hi [@dbisupport](https://wordpress.org/support/users/dbisupport/) * Thanks for your response. We are not using Redis on the application as it was causing some conflicts with plugins, so let’s assume we don’t have Redis available. * I believe the plugin uses **amazonS3_cache** as I have seen queries having this string regularly but the issue is those queries which doesn’t hit the cache. Our **wp_as3cf_items** table has **2127032** rows so whenever queries like the following one triggers, it causes a lot of resource usage and slowness. * `MariaDB [XXXXXXXX]> SELECT * FROM wp_as3cf_items WHERE (path LIKE '%uploads/ 2025/07/BVPK000273-2201478-1-300x300.webp' OR original_path LIKE '%uploads/2025/ 07/BVPK000273-2201478-1-300x300.webp'); Empty set (33.923 sec) * `MariaDB [``XXXXXXXX`]> select count(*) from wp_as3cf_items; +----------+| count(*) |+----------+| 2127032 |+----------+1 row in set (0.508 sec) * Due to the wild cards in these queries, it forces database engine to scan through 2 Million+ rows and use lots of resources. * If we use this query, it uses indexes and triggers really quick. * `SELECT * FROM wp_as3cf_items WHERE (path LIKE 'uploads/2025/07/BVPK000273-2201478- 1-300x300.webp' OR original_path LIKE 'uploads/2025/07/BVPK000273-2201478-1-300x300. webp'); Empty set (0.000 sec) * Additionally, I have tried to search for the strings **as3cf** or **S3** in debug. log but there are no such entries there. * I hope this would help you apply the required optimisations to the plugin’s code. Looking forward to your response. * Regards, Sushant Chawla * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Meta for WooCommerce] facebook-for-woocommerce plugin causing many slow queries/degrading performance](https://wordpress.org/support/topic/facebook-for-woocommerce-plugin-causing-many-slow-queries-degrading-performance/) * Thread Starter [sushantchawla2005](https://wordpress.org/support/users/sushantchawla2005/) * (@sushantchawla2005) * [7 months, 2 weeks ago](https://wordpress.org/support/topic/facebook-for-woocommerce-plugin-causing-many-slow-queries-degrading-performance/#post-18617318) * Hey [@vinkmeta](https://wordpress.org/support/users/vinkmeta/) Thanks for fixing it, now there is another slow query frequently popping up in slow logs from the same plugin: * `Time: 250828 10:35:49 User@Host: XXXXXXXX[XXXXXXXX] @ localhost [] Thread_id: 7617 Schema: XXXXXXXX QC_hit: No Query_time: 5.058751 Lock_time: 0.000038 Rows_sent: 1 Rows_examined: 251409 Rows_affected: 0 Bytes_sent: 263` * `SET timestamp=1756377349; SELECT option_valueFROM wp_optionsWHERE option_name LIKE 'wc_facebook_background_product_sync_job_%'AND ( option_value LIKE '%\"status\":\" queued\"%' OR option_value LIKE '%\"status\":\"processing\"%' )ORDER BY option_id ASCLIMIT 1; * Can you check and fix the same as well, please? * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[WP Offload Media Lite for Amazon S3, DigitalOcean Spaces, and Google Cloud Storage] Plugin causing lots of slow queries on heavy site due to wild cards](https://wordpress.org/support/topic/plugin-causing-lots-of-slow-queries-on-heavy-site-due-to-wild-cards/) * Thread Starter [sushantchawla2005](https://wordpress.org/support/users/sushantchawla2005/) * (@sushantchawla2005) * [7 months, 2 weeks ago](https://wordpress.org/support/topic/plugin-causing-lots-of-slow-queries-on-heavy-site-due-to-wild-cards/#post-18617208) * Hi, * Please check the comparison of rows examined with and without wildcard * **With wild card (1.8 Million rows examined):** * `MariaDB [XXXXXX]> EXPLAIN SELECT * FROM wp_as3cf_items WHERE (path LIKE '%uploads/ 2025/07/BVPK000273-2201478-1-300x300.webp' OR original_path LIKE '%uploads/2025/ 07/BVPK000273-2201478-1-300x300.webp'); +------+-------------+---------------- +------+---------------+------+---------+------+---------+-------------+| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |+------+-------------+----------------+------+---------------+------+--------- +------+---------+-------------+| 1 | SIMPLE | wp_as3cf_items | ALL | NULL | NULL | NULL | NULL | 1829871 | Using where |+------+-------------+---------------- +------+---------------+------+---------+------+---------+-------------+1 row in set (0.000 sec) * **Same Query** **Without wildcard (Only 2 rows examined)** * `MariaDB [XXXXXX]> EXPLAIN SELECT * FROM wp_as3cf_items WHERE (path LIKE 'uploads/ 2025/07/BVPK000273-2201478-1-300x300.webp' OR original_path LIKE 'uploads/2025/ 07/BVPK000273-2201478-1-300x300.webp'); +------+-------------+---------------- +-------------+------------------------------+------------------------------+--------- +------+------+-------------------------------------------------------------+ | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |+------+-------------+----------------+-------------+------------------------------ +------------------------------+---------+------+------+------------------------------------------------------------- +| 1 | SIMPLE | wp_as3cf_items | index_merge | uidx_path,uidx_original_path | uidx_path,uidx_original_path | 762,762 | NULL | 2 | Using sort_union(uidx_path, uidx_original_path); Using where |+------+-------------+----------------+------------- +------------------------------+------------------------------+---------+------ +------+-------------------------------------------------------------+1 row in set (0.000 sec) * This is a big difference. * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[WP Offload Media Lite for Amazon S3, DigitalOcean Spaces, and Google Cloud Storage] Plugin causing lots of slow queries on heavy site due to wild cards](https://wordpress.org/support/topic/plugin-causing-lots-of-slow-queries-on-heavy-site-due-to-wild-cards/) * Thread Starter [sushantchawla2005](https://wordpress.org/support/users/sushantchawla2005/) * (@sushantchawla2005) * [7 months, 2 weeks ago](https://wordpress.org/support/topic/plugin-causing-lots-of-slow-queries-on-heavy-site-due-to-wild-cards/#post-18617180) * Hi [@dbisupport](https://wordpress.org/support/users/dbisupport/) * As it is a high traffic website and debug.log file is getting really heavy, can you provide me with any strings which you’re looking for in debug logs, please? * For the record, we are using the following Redis configuration: * ```wp-block-code define( 'WP_REDIS_CONFIG', ['token' => "XXXX",'host' => '/var/run/redis/redis.sock','port' => 0,'scheme' => 'unix','database' => "XXXX",'timeout' => 2.5,'read_timeout' => 2.5,'split_alloptions' => true,'async_flush' => true,'client' => 'phpredis','compression' => 'zstd','serializer' => 'igbinary','prefetch' => false,'non_prefetchable_groups' => [ 'as3cf', 'yith_wcbm_badges' ],'debug' => false,'save_commands' => false,'prefix' => DB_NAME,] );define( 'WP_REDIS_DISABLED', false ); ``` * Additionally, sometimes we don’t prefer to use Redis (object-cache-pro) due to conflicts and other reasons. Does that mean this plugin amazon-s3-and-cloudfront- pro will cause thousands of slow queries if we stop using Redis? * Looking forward to your quick response. Thanks! - This reply was modified 7 months, 2 weeks ago by [sushantchawla2005](https://wordpress.org/support/users/sushantchawla2005/). * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[WP Offload Media Lite for Amazon S3, DigitalOcean Spaces, and Google Cloud Storage] Plugin causing lots of slow queries on heavy site due to wild cards](https://wordpress.org/support/topic/plugin-causing-lots-of-slow-queries-on-heavy-site-due-to-wild-cards/) * Thread Starter [sushantchawla2005](https://wordpress.org/support/users/sushantchawla2005/) * (@sushantchawla2005) * [7 months, 2 weeks ago](https://wordpress.org/support/topic/plugin-causing-lots-of-slow-queries-on-heavy-site-due-to-wild-cards/#post-18616094) * Hi, * This is urgent, can someone respond to this issue please? * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Meta for WooCommerce] facebook-for-woocommerce plugin causing many slow queries/degrading performance](https://wordpress.org/support/topic/facebook-for-woocommerce-plugin-causing-many-slow-queries-degrading-performance/) * Thread Starter [sushantchawla2005](https://wordpress.org/support/users/sushantchawla2005/) * (@sushantchawla2005) * [7 months, 3 weeks ago](https://wordpress.org/support/topic/facebook-for-woocommerce-plugin-causing-many-slow-queries-degrading-performance/#post-18602784) * Hi [@vinkmeta](https://wordpress.org/support/users/vinkmeta/) Just wanted to follow up on this issue, please confirm if we can expect a new release with the fix this week? * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Meta for WooCommerce] facebook-for-woocommerce plugin causing many slow queries/degrading performance](https://wordpress.org/support/topic/facebook-for-woocommerce-plugin-causing-many-slow-queries-degrading-performance/) * Thread Starter [sushantchawla2005](https://wordpress.org/support/users/sushantchawla2005/) * (@sushantchawla2005) * [7 months, 4 weeks ago](https://wordpress.org/support/topic/facebook-for-woocommerce-plugin-causing-many-slow-queries-degrading-performance/#post-18596774) * Thanks for your response [@vinkmeta](https://wordpress.org/support/users/vinkmeta/) I will look forward to your confirmation when the new release would be rolled out with the fix in a week’s time. Viewing 8 replies - 1 through 8 (of 8 total)