BUG: The search with elasticpress for orders is super slow between 40 and 60 sec #3707
Comments
callanerd
changed the title
|
Hi @callanerd, A couple of things there to help us understand your problem better:
|
|
Thx for your help! When you say "I used an old elasticpress version", which version was that? Failed QueriesWordPressWordPress Environmentwp_version: 6.3.2 Server Environmentphp_version: 7.4.33 Indexable Content— https://www.post_count: 11 ElasticPressSettingshost: http:// Timeoutsrequest_timeout: 5 Elasticsearch Indices-post-1health: yellow Last Sync2023/10/18 11:55:42 pmmethod: WP Dashboard Feature SettingsProtected Contentactive: true Queries infohttps://...?page=ep-query-log&settings-updated=true (2023-10-20 18:01:21)es_req: GET http://127.0.0.1:9200/_nodes/plugins https://.../?page=ep-query-log&settings-updated=true (2023-10-20 18:01:21)es_req: POST http://127.0.0.1:9200/...-post-1/_bulk result: array ( |
|
I need to add the observation that the search most of the time takes more than 40 sec. but sometimes it goes down to 6 seconds for some hours. I have no explaination for that behaviour |
|
@callanerd, looking at the queries being executed in the Orders List page, there is no search passing through ElasticPress. Are you using WooCommerce High-Performance Order Storage? Also, you may want to update ElasticPress to its latest release (5.0.0) and enable the WooCommerce feature. |
|
I activated the protected content search for the orders |
|
I'm using HPOS in compatibility mode, but before I activated HPOS search was same slow. With 5.0.0 its same. I activated the WooCommerce Feature too, and it didnt change much |
|
The backend product search is also not working anymore after activating the woocommerce search feature in elasticpress |
|
Also the order search has many wrong results after the woocomerce feature activation |
|
Hi @callanerd! After some investigation, we noticed that ElasticPress will be used only if legacy mode is enabled. If you have HPOS even in compatibility mode, queries will not go through EP. We have #3849 to track the progress of alerting users about that and also #3476 to actually implement the compatibility layer. |
Describe the bug
Hello,
first of all thank you for your overall great plugin. But the search with elasticpress for orders is super slow between 40 and 60 sec, no real improvement to the normal WooCommerce order search for large order amount in woocommerce like 250.000. I used an old elasticpress version and your extra woocommerce plugin and it always had order search result for 250.000 orders within 1 sec. I think something is wrong about the new protected content search.
Steps to Reproduce
In woocommerce shop with over 250.000 orders sync them to Elasticsearch and try order search
Screenshots, screen recording, code snippet
No response
Environment information
Newest wordpress and woocommerce
WordPress and ElasticPress information
No response
Code of Conduct
The text was updated successfully, but these errors were encountered: