Limit to custom fields

-- url of the page with the problem -- : ronaldkroezen.nl
-- HikaShop version -- : 4.2.1
-- Joomla version -- : 3.9.11
-- PHP version -- : -
-- Browser(s) name and version -- : all
-- Error-message(debug-mod must be tuned on) -- : limit

We want to make custom fields on the table products.

We want to use 'single dropdown'.

Question: is there a maximum to the number of values we can add? It can be up to 10.000 per custom field!

Jan


PS
I ask this because we tried to create a solution with Joomla Custom fields. Now are there about 1.000 fields in on dropdown and there is a limit!!!
We don't want to face this problem again!

Hi,

The only limit is the type of the column in the database. Based on your initial version of HikaShop on the website, it could be text or longtext. If it's text, then you'll be limited to a few thousand values. In which case you can switch to longtext for the field_options column (like it is by default since several years now). With longtext, the limit is around tens of millions of values and in that case, you'll have a memory issue and loading delay issue rather than a storage issue. But I doubt anyone will have so many values in one custom field.