And here are the specific tables associated with SNOMEDCT. acda27da591145d3b4e9ebf9d3c2a3e1dd4d0f40b | 0 | 16384 | a61994af45895a14eeb8f720eaba083cb9383b698 | 1 | 16384 | a494252ed0bdc44c0cac223f40735da144a347be0 | 1 | 16384 | aa337e568342857c2f7b00366cfba8c8c2859621e | 12761986 | 2353004544 |
So it's clearly the last one that takes up the most space. How close have you gotten? BTW, I think I'm going to go ahead and remove the SNOMEDCT index I have and re-create it, just to get a sense of how long that takes (it's been a while since I've done that so I don't exactly remember). Good luck, Ted On Fri, Jul 18, 2014 at 10:29 AM, Ted Pedersen <tpede...@d.umn.edu> wrote: > We have quite a few different resources indexed, so the output from your > command is a little messy. So to start with, here are the table names for > the indices associated with SNOMEDCT (available via the command shown), > This is using PAR CHD relations with SNOMEDCT in 2013AA version of UMLS... > > ted@maraca:~$ getTableNames.pl --config config/snomedct.config > > CuiFinder User Options: > --config option set > > > UMLS-Interface Configuration Information > Sources (SAB): > SNOMEDCT > Relations (REL): > CHD > PAR > Database: > umls (MMSYS-2013AA-20130404) > > > > > > The tables associated with the given configuration file are as follows: > > Table Table Name > acda27da591145d3b4e9ebf9d3c2a3e1dd4d0f40b > MMSYS_2013AA_20130404_SNOMEDCT_CHD_PAR_cache > a61994af45895a14eeb8f720eaba083cb9383b698 > MMSYS_2013AA_20130404_SNOMEDCT_CHD_PAR_child > a494252ed0bdc44c0cac223f40735da144a347be0 > MMSYS_2013AA_20130404_SNOMEDCT_CHD_PAR_parent > aa337e568342857c2f7b00366cfba8c8c2859621e > MMSYS_2013AA_20130404_SNOMEDCT_CHD_PAR_table > > > > On Fri, Jul 18, 2014 at 8:57 AM, chaitanyapshiv...@yahoo.co.in > [umls-similarity] <umls-similarity@yahoogroups.com> wrote: > >> >> >> Hello >> >> Can you share the output of the following SQL query: >> >> select TABLE_NAME,TABLE_ROWS,DATA_LENGTH from information_schema.tables >> where TABLE_SCHEMA='umlsinterfaceindex'; >> >> >> This will give us an idea of how much more we have to go. >> >> Also, is it possible for you to share the SQL dumps of the indexed >> tables. That would be awesome ! >> >> Thanks, >> Chaitanya. >> >> >> > > > > -- > Ted Pedersen > http://www.d.umn.edu/~tpederse > -- Ted Pedersen http://www.d.umn.edu/~tpederse