Posted by Greg D. Moore \(Strider\) on 10/22/07 03:30

"Neil" <nospam@nospam.net> wrote in message
news:z_SSi.59295$Um6.46164@newssvr12.news.prodigy.net...
>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.

That's still very small as far as SQL databases go.

Not sure how access documents, but a decent index on that (some sort of ID,
unique name or something) will make things work well most likely.

(BTW, you may want to look into upgrading the DB to use something like SQL
Express edition. More modern, better supported and may be a bit faster,
especially on a Windows 2003 box.)

>
> Thanks,
>
> Neil
>



--
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html

[Back to original message]