Advice

Hi everyone,

I am wanting to store documents (doc, xls, pdf, ppt...) within the DB.
Is it advisable in general (I don't know exactly how big the docs are
going to be) to compress the files before putting them into the DB?
How does this affect Full Text Searching?

Thanks for your help in advance.
Jose"Jose Perez" <jlpv@.totalise.co.uk> wrote in message
news:3724a9d9.0404130124.18bf0a3b@.posting.google.c om...
> Hi everyone,
> I am wanting to store documents (doc, xls, pdf, ppt...) within the DB.
> Is it advisable in general (I don't know exactly how big the docs are
> going to be) to compress the files before putting them into the DB?
> How does this affect Full Text Searching?
> Thanks for your help in advance.
> Jose

Although I haven't tried this myself, many people prefer to leave the binary
files in the filesystem, and store only the path to the file in the
database - this gives better performance when you need to retrieve a file.
MSSQL can still execute full-text queries on documents outside the database,
via the Indexing Service. Also, note that not all document types are
supported for indexing - .PDF is not, for example, unless you have a custom
full-text filter for it. I don't know about compressing the document before
putting it in the database, but I guess that would mean that the full-text
indexing would fail.

You should probably post this question in
microsoft.public.sqlserver.fulltext to get a better answer.

Simon|||"Jose Perez" <jlpv@.totalise.co.uk> wrote in message
news:3724a9d9.0404130124.18bf0a3b@.posting.google.c om...
> Hi everyone,
> I am wanting to store documents (doc, xls, pdf, ppt...) within the DB.
> Is it advisable in general (I don't know exactly how big the docs are
> going to be) to compress the files before putting them into the DB?
> How does this affect Full Text Searching?
> Thanks for your help in advance.
> Jose

Although I haven't tried this myself, many people prefer to leave the binary
files in the filesystem, and store only the path to the file in the
database - this gives better performance when you need to retrieve a file.
MSSQL can still execute full-text queries on documents outside the database,
via the Indexing Service. Also, note that not all document types are
supported for indexing - .PDF is not, for example, unless you have a custom
full-text filter for it. I don't know about compressing the document before
putting it in the database, but I guess that would mean that the full-text
indexing would fail.

You should probably post this question in
microsoft.public.sqlserver.fulltext to get a better answer.

Simonsql