Hi all, As an experiment I extracted my rather large HSQL UMLS dictionary into a local MYSQL instance and ran the equivalent of 3 simultaneous ctakes pipelines with the overlap lookup annotator against it with a set of 1000 notes.
Comparing that with the same setup running against the traditional in-memory HSQL database (three separate instances), I was surprised to find that the Mysql implementation it was 30% faster even though it is an out of process DB Has that been anyone else's experience as well? And if so, do you have any experience with a MYSQL based UMLS dictionary with 100+ pipeline connections? Peter
