|
|
Posted by Neil on 10/22/07 01:25
I just made a major addition to the data in our database (SQL 7 with an
Access 2000 front end). The users had been working with a set of 66,000 Word
documents, having to open each to view when needed. I converted these docs
to RTF format, and brought the RTF codes into the database itself. Each
former Word doc is now stored in a single Text field in the record; and
there is an additional Text field which is the text of the document in plain
text format. (The average document is about 1,000 characters, and the
average document with RTF codes is about 1,000-1,500 characters.)
As a result, my database went from being about 600 MB in size to a little
over a gig. Still not huge; but significant increase from it's original
size.
Since there's a big jump in the size, I was wondering if there's anything I
need to do maintenance-wise to help the database use the new data.
Thanks,
Neil
Navigation:
[Reply to this message]
|