Page 1 of 1
Option to select searchable basic fields
Posted: 16 Jan 2024, 21:45
by keep2000
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.
Re: Option to select searchable basic fields
Posted: 18 Jan 2024, 00:22
by Jan
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
Re: Option to select searchable basic fields
Posted: 18 Jan 2024, 08:37
by keep2000
Jan 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
Hi 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 :)
Re: Option to select searchable basic fields
Posted: 18 Jan 2024, 13:28
by Jan
Hi, yes, I understand:
https://github.com/PhocaCz/PhocaCart/issues/193
Thank you for the idea.
Jan