Skip to Content
Former Member
May 16, 2008 at 12:27 PM

Comparing string field



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.,)