Option to select searchable basic fields

[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.

[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

[keep2000]

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 :)

[Jan]

Hi, yes, I understand:
https://github.com/PhocaCz/PhocaCart/issues/193
Thank you for the idea.

Jan