Advice

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Jose Perez
    #1

    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
    Tags: None
    • Simon Hayes
      #2
      Re: Advice


      "Jose Perez" <jlpv@totalise. co.uk> wrote in message
      news:3724a9d9.0 404130124.18bf0 a3b@posting.goo gle.com...[color=blue]
      > 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[/color]

      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.publi c.sqlserver.ful ltext to get a better answer.

      Simon


        Comment

        • Simon Hayes
          #3
          Re: Advice


          "Jose Perez" <jlpv@totalise. co.uk> wrote in message
          news:3724a9d9.0 404130124.18bf0 a3b@posting.goo gle.com...[color=blue]
          > 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[/color]

          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.publi c.sqlserver.ful ltext to get a better answer.

          Simon


            Comment

            Previous template Next
            Working...