pyctd.update() extremely slow

cebel / pyctd

PyCTD is a Python software package to query and analyse data from the CTD database

Apache License 2.0

11 stars 4 forks source link

pyctd.update() extremely slow #26

Closed g-simmons closed 2 years ago

g-simmons commented 5 years ago

After a bandaid fix for the error encountered in #25 , I can run pyctd.update() without error so far.

However, it's taking a rather long time. It has been stuck on import_one_to_many() for the gene__disease table for around three hours now, with the total process so far taking somewhere around five hours. Is this typical?

I am using a newer Macbook Pro, 16GB RAM.

g-simmons commented 5 years ago

Finally finished after about 8 hours.

cebel commented 2 years ago

My general recommendation is MySQL as RDBMS.