This topic contains a post which is marked as Best Answer. Press here if you would like to see it.
*

Cecile D

  • **
  • 27 posts
category fiels
« 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

*

MB Themes

Re: category fiels
« Reply #1 on: August 13, 2024, 08:25:11 AM »
Why it should be huge?
  To get fast support, we need following details: Detail description, URL to reproduce problem, Screenshots

*

Cecile D

  • **
  • 27 posts
Re: category fiels
« Reply #2 on: August 13, 2024, 01:48:17 PM »
if you have a lot of categories. i you need to associated them to attribute

Marked as best answer by frosticek on August 14, 2024, 07:44:17 AM
*

MB Themes

Re: category fiels
« Reply #3 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...
  To get fast support, we need following details: Detail description, URL to reproduce problem, Screenshots

*

Cecile D

  • **
  • 27 posts
Re: category fiels
« Reply #4 on: August 13, 2024, 10:04:12 PM »
Thank you