PHPJunkyard support forum

Posted: **Sun Oct 21, 2018 1:51 pm**

Ver 2.8.1

Hi team

Can i change type of cat_order and id column in categories table to varchar(60) or int(9) from smallint(5) ??

It has other dependencies or not? As my category count would be approx 0.5 million..

Posted: **Sun Oct 21, 2018 4:06 pm**

You can change them from SMALLINT to INT without problems (though MEDIUMINT should be plenty).

The real question is how 0.5 million categories will work in Hesk, could get messy or slow loading in the browser (the display of them) and I have no idea how users will find the correct one... You might want to rethink it.

Posted: **Mon Oct 22, 2018 12:10 pm**

Also, who has the time to enter half-a-million categories into the system?

PHPJunkyard support forum

SQL Issues - Max rows in categories table

SQL Issues - Max rows in categories table

Re: SQL Issues - Max rows in categories table

Re: SQL Issues - Max rows in categories table