Does anyone know if this ticket is going to be worked in the near future? I know we opened this last October while upgrading to OpenMRS 1.7. This is currently the only ticket keeping CHICA from using OpenMRS as is. Currently we have a patch that we have to apply to fix the slow query issue before deployment. Our patch removes the ilike completely and just uses a like since MySQL is case insensitive. It also does an equals instead of a like when the "searchOnPhrase" is null to help performance.
This affects class: org.openmrs.api.db.hibernate.HibernateConceptDAO.java method getConcepts. https://tickets.openmrs.org/browse/TRUNK-2767 Thanks, Steve _________________________________________ To unsubscribe from OpenMRS Developers' mailing list, send an e-mail to [email protected] with "SIGNOFF openmrs-devel-l" in the body (not the subject) of your e-mail. [mailto:[email protected]?body=SIGNOFF%20openmrs-devel-l]
