Hi All,
Firstly, thanks for your contribution to this bravo project. And I see a tips below about sstCacheSize.
So, Should I avoid to use sstCacheSize feature ?
/**
!!! This option is experimental !!!
Set the size of the Shared Strings Table cache. This option exists to accommodate
extremely large workbooks with millions of unique strings. Normally the SST is entirely
loaded into memory, but with large workbooks with high cardinality (i.e., very few
duplicate values) the SST may not fit entirely into memory.
By default, the entire SST will be loaded into memory. Setting a value greater than
0 for this option will only cache up to this many entries in memory. However,
enabling this option at all will have some noticeable performance degredation as you are
trading memory for disk space.
@param sstCacheSize size of SST cache
@return reference to current {@code Builder}
*/
public Builder sstCacheSize(int sstCacheSize) {
this.sstCacheSize = sstCacheSize;
return this;
}
Hi All, Firstly, thanks for your contribution to this bravo project. And I see a tips below about sstCacheSize. So, Should I avoid to use sstCacheSize feature ? /**
!!! This option is experimental !!!