1. ENUM type of data in MySQL database. For example: 'Male,'Female' options
2. Values founded in another table. For example: Civil state (Married, Single, etc.)
When I try to fill or change a record on this table, first option is very slow searching the possible options (Male, Female). In the second option, finding values is instantaneous.
I've made a table with two type of fileds:
1. ENUM type of data in MySQL database. For example: 'Male,'Female' options
2. Values founded in another table. For example: Civil state (Married, Single, etc.)
When I try to fill or change a record on this table, first option is very slow searching the possible options (Male, Female). In the second option, finding values is instantaneous.
¿Is it normal?
Hi Jose
Thank you for reaching out to us.
Can you please show us the query used to create the table? Do you have the same issue with server side processing off?
Can you provide us with a link to the front end where we can see this behavior?