Using a mysql database with two columns. One column is an index. The second column holds a comma deliminated text string. When called, PHP splits the string into about 70 substrings or variables. Would it be better overall to store the complete variables ie:"The house is red." in the mysql string OR would it be better to store the variable as "y" in the string and use a PHP function to create "The house is red." when the value = "y" ? My concern is will the 70 plus functions bottle neck the server if many queries are made. Or will the larger record slow MYSQL. The string using complete substrings would be about 15k. The string using one character substrings would be about 1k per record. Left or right, what do you think?
