1 Reply Latest reply: Jul 24, 2012 4:19 AM by Chrisjenkins-Oracle RSS

    How to compress CHAR before storing it in the Timesten DB table ?

    945032
      One data is type of CHAR, maximum length is 100. Usually we will use the Timesten datatype VARCHAR(100) to store it. To save the Timesten memory usage, I would like to find the way to compress the data before storing it in the Timesten table. Can I use the zip/gzip or any other ways to perform the compress ?
        • 1. Re: How to compress CHAR before storing it in the Timesten DB table ?
          Chrisjenkins-Oracle
          TimesTen does not have any built in compression of this sort but you are of course free to compress the data in the application before storing it and decompress it when you retrieve it. Some things to consider however:

          1. This kind of compression is CPU intensive. If you apply it to a lot of columns and/or large data values then you will reduce performance. You may well reduce it so much that there is no longer any benefit in using a fast database like TimesTen.

          2. You will not be able to use compressed columns in any kind of WHERE clause predicate or SQL function.

          Chris