Maximum size of sym file on kdb+3.5

Community Support
1

Hi there,

 

Does anyone know what the maximum limit of the sym file size is on kdb+ version 3.5?

 

Thank you! 

2

Hi araza,

 

At 3.5, it’s still limited to a 32-bit space (so 2^32 worth).

From 3.6, it’s 64-bit, see https://code.kx.com/q/releases/ChangesIn3.6/#nucs-not-upwardly-compatible

 

Curious what you’re doing with the sym file though?

Large sym files in HDBs generally reload and write-down times, so it’s generally not a good idea, eventually leading to a need for sym file compaction: https://code.kx.com/q/kb/compacting-hdb-sym/

 

Cheers,

Sean

3

Hi Sean,

Appreciate your help!

We were monitoring our sym file, so just wondering what the hard limit on its size was. Definitely want to avoid doing a sym file compaction.

 

Thanks,

Abbas