Andy Alexander wrote:
I have a question regarding datatype (SQL 2000).
I need to store a large amount of data (text) for
multiple users.
Here are the details
The text may vary in size from NULL - 32,000 chars.
text is about your only option here.
The actual text never needs to be seatched (entire
field is loaded based on user_ID), so no need for
index -- (I assume)
if the data is related to a user, that field would be the
one indexed.
The text needs to be loaded all at once (and will be
accessed frequently)
all at once for the one user, or the same data is read
for multiple users? does frequently mean read from,
written to? and does that apply to multiple users
writing to, or one?
how frequent is frequent? how many users?
As mentioned earlier, there will be multiple users,
each with up to 32,000 chars of text.
The only two ways I can think of to store this data
are:
Text Field -- store all text in one field with a
datatype of 'text' and load the entire field every
time it is needed
VARCHAR(8000) field -- when the data is entered, break
it in to 8000 char chunks. and store in database with
user_ID and chunk (and posible tinyint to store the
chunk #). Then, when needed, load and attach all
chunks for the specified user_ID.
Which of these ways (or any other ways that I haven't
mentioned) is the best.
best to use a text field, or perhaps a flat text file.
--
-----------------------------------------------------------------------
Michael J. Ryan | ICQ: 4935386
tracker1(at)theroughnecks(dot)com | AIM/AOL: azTracker1
Roughneck BBS: | Yahoo: azTracker1
http://www.theroughnecks.net | MSN: (email address)
telnet://theroughnecks.net | Trillian: www.trillian.cc
---
You are currently subscribed to activeserverpages as: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]
