Synonym lookup super slow? How to fix?

[edeutsch]

I've noticed this for a while, but only posting now. Has anyone noticed that the Synonym lookup through the ARAX GUI is super slow? Try searching for metformin or ibuprofen or anything reasonably common, and I start hearing my CPU fans groaning and it takes 15+ seconds for something to appear. I assume this is either because so much data is returned or rendering the graph is so expensive or? I wonder if anyone else has this issue? And if anyone has ideas on how best to solve it? Return less data? Don't render the graph unless asked? This service was great when answers came back within a second, but now it's painful to use.

ideas?

[amykglen]

yes, this started happening after we started using the SRI Node Normalizer's drug_chemical_conflate parameter, which made the clusters for certain drugs really big.

I definitely think it's the 'match graph' that's causing the issue (I think the acetaminophen graph has 10s of thousands of edges now) - I wonder if we could just not display the graph if it has more than some reasonable number of edges? not sure if there's an existing way to determine the number of edges without actually having to load all of them..

[isbluis]

As a quick test in devLM, looking up metformin results in the following rough timings:

• 13 seconds to receive JSON response (>77Mb)
• 35 seconds to render full table, without displaying the Concept Graph
• 55 seconds to display, including graph

[edeutsch]

oof, thanks. Yeah, I think we should put some effort into slimming down the response first somehow. And then maybe something on the front end.