if you can't change database configurations you can do something like this:
- create a DB table with 2 column (value,text)
- put your options in this db table
- Set select field to retrieve info from this table (see screenshot)
Not sure re timeout error - I cannot save the 5000 options in the Options List (one per line, separate the value from the text with the character '|').
I mean, I paste the options but after I save - they disappear.
Hi,
could be due to a configuration of MySQL, the database server typically have a size limit for queries. a query to save 5000 options is huge. In any case, even if I could save them then you will have a very very slow page and almost certainly timeout errors (browser and/or server).
