Problem solved. The index was missing. >From : [email protected] [mailto:[email protected]] Sent : February-18-16 9:39 AM To : [email protected] 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
