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 |