Home › Forums › Back End › Long String in PHPMYSQL › Reply To: Long String in PHPMYSQL
November 27, 2013 at 1:38 am
#157218
Participant
Hello
may is it possible to “normalize” data?
May it can be split into few fields or many records. TEXT data fields are not indexed normally and are SLOWER, than VARCHAR or CHAR. If you have only ten or few hundreds records, may you test to keep one data unit in one table or all data units in two fields – one field could be record id (this will be not primary key, because many words will be assigned to this id) and field for word. Simply do tests.