ctakes-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From <Michal.Iglew...@uqo.ca>
Subject RE: mysql slow
Date Thu, 25 Feb 2016 22:11:14 GMT
Problem solved. The index was missing.

>From : Michal.Iglewski@uqo.ca [mailto:Michal.Iglewski@uqo.ca]
Sent : February-18-16 9:39 AM
To : user@ctakes.apache.org
Subject : mysql slow

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