You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@ctakes.apache.org by Mi...@uqo.ca on 2016/02/18 15:38:35 UTC

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

RE: mysql slow

Posted by Mi...@uqo.ca.

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