Skip to main content

Timeline for Optimizing a MySQL "IN" query

Current License: CC BY-SA 3.0

2 events
when toggle format what by license comment
Dec 12, 2015 at 1:44 comment added Scott Deerwester Unfortunately, the query isn't under my control. It's taken from a selection of a terminology called RxNorm, as used by a healthcare information system standard called FHIR. I think that what I'm going to have to do is "precompute" queries like these (there aren't many of them) and add a column that I can use to retrieve the results efficiently. Not ideal.
Dec 12, 2015 at 1:42 history answered Rick James CC BY-SA 3.0