[glotpress-updates] [GlotPress] #389: Improve performance of GP::Original->by_project_id_and_entry by using the index

[GlotPress]

#389: Improve performance of GP::Original->by_project_id_and_entry by using the
index
-----------------------+-----------------------------
 Reporter:  yoavf      |      Owner:
     Type:  defect     |     Status:  new
 Priority:  normal     |  Milestone:  Awaiting Review
Component:  Database   |    Version:
 Keywords:  has-patch  |
-----------------------+-----------------------------
 `GP::Original->by_project_id_and_entry` does not currently use the index
 on the originals table because the `BINARY` modifier in the query is
 before the column name. Applying the modifier to the value instead of the
 column will give the same result with the added benefit of using the
 index.

--
Ticket URL: <https://glotpress.trac.wordpress.org/ticket/389>
GlotPress <https://glotpress.trac.wordpress.org>
Easy comin', easy goin'