lundi 29 juin 2015

best way to store a 3k string on mysql varchar vs text for infrequent reads

I decided to store a json string on mysql database. The data will be read infrequently, maybe 5-10 times max, where 10 times is highly unlikely. So what are my most logical options? TEXT BLOOB VARCHAR?

Will TEXT OR BLOOB be more suitable for this situation or I should stick with VARCHAR? I know varchar is stored inline and text/bloob stored offtable.

Any help would be appreciated!

Aucun commentaire :

Enregistrer un commentaire