Forum Replies Created
-
wpsolrKeymaster7 years, 3 months ago in reply to: Send data tab takes 22 minutes to load #12500
Here is a new version with the fix: https://www.dropbox.com/s/r9zyw53xx2kat03/wpsolr-pro-taxonomies-indexing-fast.zip?dl=0
Tested with 10,000 terms indexed in Elasticsearch. At least as fast as with post types indexing.
wpsolrKeymaster7 years, 3 months ago in reply to: Send data tab takes 22 minutes to load #12499I made my tests with 1000 terms, and everything was good.
But with 10,000 terms, the SQL to retrieve terms is really slow. It appears a “sql inner join” between 10 thousands and 10 thousands terms is not viable.
I made some preliminary tests to replace it with a slightly modified ” sql union”, and it’s very fast for the same 10 thousand terms.
After verification of the speed, I’m now checking if all the other parts of the indexing code can be adapted too. Not trivial, because the code was custom built around the “sql inner join”.
wpsolrKeymaster7 years, 3 months ago in reply to: Product found in instant search but not on search result page #12497A WPSOLR test index, rather than one of your local indexes?
wpsolrKeymaster7 years, 3 months ago in reply to: Send data tab takes 22 minutes to load #12463The queries are the ones you sent me already.
wpsolrKeymaster7 years, 3 months ago in reply to: Send data tab takes 22 minutes to load #12461I will make stress tests.
The difference between taxonomy and post types indexing is that taxonomy terms does not have a publication date. Hence, no way to perform incremental indexing. So, the query that retrieves taxonomy terms to index is a join with a custom table that stores the last indexed date for the taxonomy terms. This join could be the reason of the slowness.
wpsolrKeymaster7 years, 3 months ago in reply to: Send data tab takes 22 minutes to load #12458I guess “book author” is a product attribute. How many terms in it?
wpsolrKeymaster7 years, 4 months ago in reply to: Send data tab takes 22 minutes to load #12454Can you deselect all taxonomies in screen 2.1, to keep only your post types, and see if things are faster?
Or you can deselect taxonomies in the indexing screen to check the indexing speed.
Which screen 2.3 ? (“Search” or “suggestions”)
wpsolrKeymaster7 years, 4 months ago in reply to: Product found in instant search but not on search result page #12452I made some tests locally. I indexed “Zepres tablet 5 mg 2×10’s” with a local Elasticsearch index.
I can retrieve the title both in suggestions and in search results for “Zepres”.
Can you create a WPSOLR test index, index it with your data, and switch to the temp index when searching in screen 2.1? Then make your test again with “Zepres”
wpsolrKeymaster7 years, 4 months ago in reply to: Quicksearch results by Taxonomies as well as Products #12417I just tried, and the download went ok (512Kb). You can check in the plugin folders.
wpsolrKeymaster7 years, 4 months ago in reply to: Quicksearch results by Taxonomies as well as Products #12405Version 21.5 has now been released.
wpsolrKeymaster7 years, 4 months ago in reply to: autosuggest filter(s) #123901) I don’t think there is a universal way to filter the suggestions with a UI element defining a specific term.
To do that, we should be able to define a way to collect the term value, from the UI element. It could be done with a jQuery selector. But it depends on the UI itself. For instance, the UI could be a simple html select. Or a js select2 select. Or a js chosen select.
And instead of a term, it could be a post type (‘Product/Post/Page’), or a product attribute (‘blue/red/yellow’ color), or a location, or any custom field.
2) The other way to do it is by building specific extensions for some popular themes.Those themes already collects the UI element value, and pass it to their Ajax suggestion call. Now, it’s just a question to use hooks in the backend to get the element value and add a filter to the Elasticsearch/Solr query.
WPSOLR has done just that for Listify and Jobify. But it depends on the theme’s hooks. Sometimes, it simply cannot be done.wpsolrKeymaster7 years, 4 months ago in reply to: Quicksearch results by Taxonomies as well as Products #12389Here is the link (for an hour): https://www.dropbox.com/s/v2w81p5ckxhsu6i/wpsolr-pro-twig-2.zip?dl=0
wpsolrKeymaster7 years, 4 months ago in reply to: Quicksearch results by Taxonomies as well as Products #12385@Jezzz can you create a new topic in /forums/forum/technical-configuration-issues/new-features-requests/ ?
wpsolrKeymaster7 years, 4 months ago in reply to: Quicksearch results by Taxonomies as well as Products #12384Here is the release with Twig templates:
https://www.dropbox.com/s/wzgg4xzo0djhqvn/wpsolr-pro-twig-1.zip?dl=0Just follow the download example links in screen “2.3 Suggestions”.
wpsolrKeymaster7 years, 4 months ago in reply to: Quicksearch results by Taxonomies as well as Products #12380Could you send me the links to those demos?