SQLITE and unity performance

hi
is it better to save data like (int, int, string, int) as a diffrent fields or
the way im doing it currently combine them all into a string separate them with ‘|’ and save them as TEXT
when i load i parse each field into its type
just asking if this is bad for performance, saving and loading can happen every 2~ min and might save this way 1 object or 1k

It is better to save each value into their own column in your tables.


I suggest you go learn about some basic database design principals as it sounds like you are not all that comfortable with how relational databases work.


Maybe start with database normalisation