How about a mapping table and a view? Your varchar column would be replaced by an int or even by a tiny int.
On Monday, 7 July 2014 19:14:03 UTC-4, gaurav wrote: > > Is there any option to reduce space usage for varchar type columns when > the values for some of the columns may be repeated, below is an example > dataset: > > SYSPLEX SYSTEM SUBSYSTEM > > ---------------------------------------------------------------------------- > PLEX1 CA11 SBS1 > PLEX1 CA11 SBS2 > PLEX1 CA31 SBS3 > PLEX1 CA31 SBS4 > > > this is a very small example dataset but hope it gets the point across > that what I'm looking for is a way to make h2 store the repeated strings > "PLEX1", "CA11", "CA31" only once and use internal id's instead to save > disk space when there any many many rows like this with much more columns. > Is it possible to do so with some configuration option? I couldn't find > something like this going through the various documentation or forum posts > here but may be I missed something. > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
