SQL Issues - Max rows in categories table

davkan · Post by **davkan** » 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..

Post by **Klemen** » 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.

alcazar · Post by **alcazar** » 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