Maximum size of sym file on kdb+3.5

[araza]

Hi there,

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

Thank you! 

[sean185 · Accepted solution]

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

[araza]

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