Hi
https://www.phoca.cz/documentation/115- ... phoca-cart
It lists some basic fields that are searched: title, alias, metakey, metadesc, description, etc.
As far as I can see, it's hardcoded, but I don't need to search the meta fields and the description, just the title and EAN.
Would you consider adding a selector to the config where the admin could pick where the search would be performed? It might increase the mysql performace as well, to skip some text fields.
Option to select searchable basic fields
-
- Phoca Enthusiast
- Posts: 50
- Joined: 14 Nov 2022, 12:04
- Jan
- Phoca Hero
- Posts: 48287
- Joined: 10 Nov 2007, 18:23
- Location: Czech Republic
- Contact:
Re: Option to select searchable basic fields
Hi, in Phoca Cart Options, in main tab, in advanced section, you can skip some SQL queries (parts) which are significant for performance. The search for the product columns is hardcoded, because all columns are in the same table (no join, etc.) and skipping some of them does not bring some significant improvement regarding performance.
The parameter for skipping search in description_long and features is called "Deep Search"
Jan
The parameter for skipping search in description_long and features is called "Deep Search"
Jan
If you find Phoca extensions useful, please support the project
-
- Phoca Enthusiast
- Posts: 50
- Joined: 14 Nov 2022, 12:04
Re: Option to select searchable basic fields
Hi JanJan wrote: ↑18 Jan 2024, 00:22 Hi, in Phoca Cart Options, in main tab, in advanced section, you can skip some SQL queries (parts) which are significant for performance. The search for the product columns is hardcoded, because all columns are in the same table (no join, etc.) and skipping some of them does not bring some significant improvement regarding performance. :idea:
The parameter for skipping search in description_long and features is called "Deep Search"
Jan
Thanks for the reply. The performance aspect is just a minor concern. The site owner doesn't want the short description to be searchable; only the title and EAN should be searchable, and nothing else. The main reason for the question is to make it possible to choose which fields are searchable, a.k.a. setting for searchable areas :)
- Jan
- Phoca Hero
- Posts: 48287
- Joined: 10 Nov 2007, 18:23
- Location: Czech Republic
- Contact:
Re: Option to select searchable basic fields
If you find Phoca extensions useful, please support the project