ILIKE Ticket TRUNK-2767

classic Classic list List threaded Threaded
3 messages Options
sjmckee sjmckee
Reply | Threaded
Open this post in threaded view
|

ILIKE Ticket TRUNK-2767

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

 


[hidden email] from OpenMRS Developers' mailing list
Ben Wolfe (openmrs) Ben Wolfe (openmrs)
Reply | Threaded
Open this post in threaded view
|

Re: ILIKE Ticket TRUNK-2767

Sorry about the delay.  It is not scheduled yet, and probably hasn't hit the lists of bugs to focus on because it has zero votes.  Click the "vote" button on the right-hand side to increase its visibility.

If you have a patch that doesn't change the current functionality, please apply it to the ticket.  That will make it 10x faster to get it applied and backported!

Ben

On Wed, May 9, 2012 at 10:51 AM, McKee, Steven Jay <[hidden email]> wrote:

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

 


[hidden email] from OpenMRS Developers' mailing list


[hidden email] from OpenMRS Developers' mailing list
sjmckee sjmckee
Reply | Threaded
Open this post in threaded view
|

Re: ILIKE Ticket TRUNK-2767

I’ll do the vote.  The patch I have will affect databases other than MySQL, so it wouldn’t be the best to include.

 

Steve

 

From: [hidden email] [mailto:[hidden email]] On Behalf Of Ben Wolfe
Sent: Wednesday, May 09, 2012 11:07 AM
To: [hidden email]
Subject: Re: [OPENMRS-DEV] ILIKE Ticket TRUNK-2767

 

Sorry about the delay.  It is not scheduled yet, and probably hasn't hit the lists of bugs to focus on because it has zero votes.  Click the "vote" button on the right-hand side to increase its visibility.

If you have a patch that doesn't change the current functionality, please apply it to the ticket.  That will make it 10x faster to get it applied and backported!

Ben

On Wed, May 9, 2012 at 10:51 AM, McKee, Steven Jay <[hidden email]> wrote:

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

 


[hidden email] from OpenMRS Developers' mailing list

 


[hidden email] from OpenMRS Developers' mailing list


[hidden email] from OpenMRS Developers' mailing list