I'm not entirely sure if it is supposed to work this way or not:
We setup WordPress + WooCommerce + StoreFront theme + ElasticSearch and loaded sample data
Installed and activated Elasticsearch Indexer Plugin
Run reindex all
Index in elasticsearch got populated with all the correct data.
PROBLEM:
When I open home /shop/ page, search results page, or product page - debug output displays that the page executed [nn] number of MySql Queries and [y] number of ElasticSearch queries.
QUESTION:
1
I'm wondering if it actually is executing all those mysql query and if there's a reason for running mysql queries to select current document if it's already being selected by elasticsearch anyway? And if so - what is the benefit of running elasticsearch in addition to mysql queries? Is the module designed to pull in additional search results and combine them with what was already selected from mysql? Or is the module supposed to be a replacement for the frontend to eliminate need to query mysql whenever possible?
2
Is it possible to reference elasticsearch document response via some of the default WooCommerce methods?
ie:
$product = new WC_Product(get_the_ID());
is it configurable to be able to access all postmeta values from elasticsearch response document? or is there a different / proper way to access elasticsearch's response data?
Hello,
I'm not entirely sure if it is supposed to work this way or not: We setup WordPress + WooCommerce + StoreFront theme + ElasticSearch and loaded sample data
PROBLEM: When I open home /shop/ page, search results page, or product page - debug output displays that the page executed [nn] number of MySql Queries and [y] number of ElasticSearch queries.
QUESTION:
1
I'm wondering if it actually is executing all those mysql query and if there's a reason for running mysql queries to select current document if it's already being selected by elasticsearch anyway? And if so - what is the benefit of running elasticsearch in addition to mysql queries? Is the module designed to pull in additional search results and combine them with what was already selected from mysql? Or is the module supposed to be a replacement for the frontend to eliminate need to query mysql whenever possible?
2
Is it possible to reference elasticsearch document response via some of the default WooCommerce methods? ie:
$product = new WC_Product(get_the_ID()); is it configurable to be able to access all postmeta values from elasticsearch response document? or is there a different / proper way to access elasticsearch's response data?
Thank you.