# RE: \[personal kdb+\] Large sym enumeration file

**URL:** https://forum.kx.com/t/re-personal-kdb-large-sym-enumeration-file/10140
**Category:** Community Support
**Tags:** kdb-and-q, imported
**Created:** [July 17, 2015, 5:09pm UTC](https://forum.kx.com/t/re-personal-kdb-large-sym-enumeration-file/10140 "2015-07-17T17:09:00Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![david\_demner](https://avatars.discourse-cdn.com/v4/letter/d/7993a0/32.png) [@david\_demner](https://forum.kx.com/u/david_demner)
#### Post date: [July 17, 2015, 5:09pm UTC](https://forum.kx.com/t/re-personal-kdb-large-sym-enumeration-file/10140/1 "2015-07-17T17:09:00Z")

</div>

User-Agent: Workspace Webmail 5.14.9Message-Id: \<20150717090912.85f80dae80d1d2f2e266ec6278e6cbe8.e0ba047d85.wbe@email07.europe.secureserver.net\>From: “David Demner (AquaQ)” \<david.demner\>To: personal-kdbplus@googlegroups.comSubject: RE: [personal kdb+] Large sym enumeration fileDate: Fri, 17 Jul 2015 09:09:12 -0700Mime-Version: 1.0

http://code.kx.com/wiki/Contrib/CompactingHdbSym

  

I did this a few months ago and the system did get a bit more stable/responsive.

  

Fairly painful but the only way is to rewrite all your sym columns (after you change the offending column to string as you say).

  

Good luck....
 

>