Support Forums - Classified Ads Script Osclass

Osclass plugin support => Attributes Plugins => Topic started by: Cecile D on August 13, 2024, 02:30:12 AM

Title: category fiels
Post by: Cecile D on August 13, 2024, 02:30:12 AM
Sure I am not sure it is a good ide to have s_category_id is field table were you put all category belonging to the field. this is forcing to do long scan to the field. can we have a table category field to link both of them instead of having this huge text field
Title: Re: category fiels
Post by: MB Themes on August 13, 2024, 08:25:11 AM
Why it should be huge?
Title: Re: category fiels
Post by: Cecile D on August 13, 2024, 01:48:17 PM
if you have a lot of categories. i you need to associated them to attribute
Title: Re: category fiels
Post by: MB Themes on August 13, 2024, 02:28:54 PM
Index that column.
I do not consider varchar 1000 huge, as osclass description might be easily 20000 of characters...
Title: Re: category fiels
Post by: Cecile D on August 13, 2024, 10:04:12 PM
Thank you