Hi,
If we are using a string variable 4000 length in a db table..
which will be like follows :
apid int 6
prid int 6
text string 4000
Second database design:
apid int 6
prid int 6
lines int 4
text 70
In first DB we will store all the characters from a text editor,concatenate and put in to tht field..Here it is in 1 record.
In second DB if there are 10 lines in Text editor am putting it as ten lines in database so it will be 10 records..
For retrieving and inserting whcih Databse design will be good in all circumstances(performance,speed etc.,)