Option to select searchable basic fields

Phoca Cart - complex e-commerce extension
keep2000
Phoca Enthusiast
Phoca Enthusiast
Posts: 50
Joined: 14 Nov 2022, 12:04

Option to select searchable basic fields

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

Tags:
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 48287
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: Option to select searchable basic fields

Post 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. :idea:

The parameter for skipping search in description_long and features is called "Deep Search"

Image

Jan
If you find Phoca extensions useful, please support the project
keep2000
Phoca Enthusiast
Phoca Enthusiast
Posts: 50
Joined: 14 Nov 2022, 12:04

Re: Option to select searchable basic fields

Post 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 :)
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 48287
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: Option to select searchable basic fields

Post by Jan »

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

Jan
If you find Phoca extensions useful, please support the project
Post Reply