Forums

The forums ran from 2008-2020 and are now closed and viewable here as an archive.

Home Forums Back End Long String in PHPMYSQL Reply To: Long String in PHPMYSQL

#157218
ugnelakys
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.