92 columns or 1 longtext

[mga_ka_php]

which is better to have create a 92 table columns or concatenate the values with delimiter and save it into 1 column (longtext)? which is faster to retrieve data from database

 

example 1 column in longtext

IdNumber:123[delimiter]Description:the quick brown fox[delimiter]LongDescription: ..........

 

or i will separate that into 92 columns.

[trq]

Having all the data in one field will inhabit your ability to query on specific data. You might not need 92 separate fields either if you normalize your data somewhat.

[mga_ka_php]

so what is the best solution?

[trq]

Well, I would never store data in one long delimited string in a database. You loose too much of the flexibility that comes with using a database.

[mga_ka_php]

then what is the best solution? this is a big database. i want to optimize the database of our site because our server load is very high, it makes the site slow. i'm trying to optimize also the web pages.

[PFMaBiSmAd]

Your example implies the need for three columns. Without specific information about what the data is and how it is used, we cannot directly help you. The solution might range from a single table with some of the data in discrete columns and some of it stored as a list in one column all the way to some of the data separated out into separate tables.

[fenway]

Sounds like you need an EAV table.