samedi 20 septembre 2014

store many data in a string (CHAR) vs many columns?


Vote count:

-1




Can anyone list me each datatype's memory usage in phpmyadmin ? (for bit,boolean,char,tinyint and etc)


also which is better to store many data in a text string or many columns ?


is it better this one (will store in array on php script)


with tinyint


or this one (will store in array on php script + data slicing)


with char(9)


P.S: my aim to make the server process not heavy



asked 1 min ago







store many data in a string (CHAR) vs many columns?

Aucun commentaire:

Enregistrer un commentaire