ctakes-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From <Michal.Iglew...@uqo.ca>
Subject mysql slow
Date Thu, 18 Feb 2016 14:38:35 GMT
Hi,

I'm using 3.2.3 on windows 7 with umls installed locally. Mysql is very slow. In particular,
the query
ResultSet rs = _preparedStatement.executeQuery()
in ctakes-dictionary-lookup/src/main/java/org/apache/ctakes/dictionary/lookup/ae/UmlsToSnomedDbConsumerImpl.java
takes 12sec while the same query
select cui from mrconso where cui="patient"
executed directly from mysql is instantaneous.
Does anybody know how to improve this performance?

Michal

Mime
View raw message