Using Data Compression on a Full Text Index ?

  • Will this improve performance or is it a bad idea?

    Thanks

  • I would think that building the index on compressed data would take a bit longer due to the compress/decompress (higher cpu utilization).

    The queries against them should take a comparable amount of time as against the data as other queries, allowing from slightly more time for decompression.

    That is my theory based on some research. Definately not a definitive answer.

    Keep in mind that data compression is not a performance enhancing option. Rather it is a resource conservation option. You need to perform some testing and compile a list of pros and cons to compare.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply