RXNORM installation hangs

Management and Administration
1

drpwayne wrote on Friday, November 28, 2014:

I have been importing code sets into OpenEMR through admin->other->external database import. I had no trouble with SNOMED and ICD9. When I try to import RXNORM, though, the system seems to hang. The import has been going on for more than 2 hours and I don’t believe any progress is being made. When I do a SHOW FULL PROCESSLIST in mysql, I set that the system is stuck at LOAD DATA INFILE for RXNSAT with a state of NULL. I realize that there are many rows in RXNSAT but does it take many hours? Even after 2 hours if I do a
SELECT COUNT(*) FROM RXNSAT I get a result of 0 – after about 4 minutes of waiting.
I am using a development build from the past weekend.
Thanks for any guidance.

2

cmswest wrote on Friday, November 28, 2014:

Did it finish or is it still loading?

3

cmswest wrote on Friday, November 28, 2014:

it took about an hour and twenty minutes loading on dev debian package:

mysql> SELECT COUNT() FROM RXNSAT;
±---------+
| COUNT() |
±---------+
| 7802781 |
±---------+
1 row in set (7.90 sec)

7.8 million rows!

this was on an older hp pavilion with 3 gb memory running
stephen@debian:~/Downloads$ uname -a

SMP Debian 3.2.60-1+deb7u3 x86_64 GNU/Linux

stephen@debian:~/Downloads$ lscpu

Architecture: x86_64
CPU op-mode(s): 32-bit, 64-bit
Byte Order: Little Endian
CPU(s): 2
On-line CPU(s) list: 0,1
Thread(s) per core: 1
Core(s) per socket: 2
Socket(s): 1
NUMA node(s): 1
Vendor ID: GenuineIntel
CPU family: 6
Model: 15
Stepping: 13
CPU MHz: 2000.000
BogoMIPS: 3999.89
L1d cache: 32K
L1i cache: 32K
L2 cache: 1024K
NUMA node0 CPU(s): 0,1