Database Design: Database with large amount of text.

Question

Post reply

Database Design: Database with large amount of text.

fryere

Ten Centuries

Points: 1054
More actions
January 6, 2005 at 2:15 pm

#86201

I may need to design a database that will have an Avg of 1220 bytes and a max of 6900 bytes in one of the fields. The data in this field will be the reason users access the database. There isn't really a way to break it up into different fields. I was just curious if anyone had any tips on the best way to handle this.

Thanks
fryere
fryere

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

K. Brian Kelley SSC Guru Points: 114642 More actions · Answer 1

What is the total maximum size of a row (record) given the 6900 bytes?

K. Brian Kelley
@kbriankelley

fryere Ten Centuries Points: 1054 More actions · Answer 2

I will have 4 fields that have open text, which I plan on making a varchar type and limit to 8000 chars. One of these fields is a 'Notes' field and could be saved in another table. Two other would probably have a max of 2000 chars while the last one may get close to the max on occassion.

6 other text fields that the max would be 100 chars.

A few other Bit and one Int(PK).

fryere

Antares686 SSC Guru Points: 125444 More actions · Answer 3

Generally you have two options, 1 make a text field or 2 place each into a seperate table which can be joined to to rebuild the original required results. But I would prefer to see what you table would look like as a single thing ignoring the 8K limit just to see what you are dealing with.

fryere Ten Centuries Points: 1054 More actions · Answer 4

Just to update those who replied. The database runs faster than I would have thought. The design that I came up with was to only pull in the Main text field when the form loads. Then the user can click a button to view one of the other large text fields.

Thanks

fryere