This content has been marked as final. Show 1 reply
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.