[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:  1.0
 Component:  Database  |    Version:
Resolution:            |   Keywords:  has-patch commit
-----------------------+------------------------------
Changes (by ocean90):

 * keywords:  has-patch => has-patch commit
 * milestone:  Awaiting Review => 1.0


Comment:

 Looks good.

 `EXPLAIN SELECT * FROM gp_originals WHERE (context IS NULL OR NULL IS
 NULL) AND BINARY singular = "A GlotPress" AND BINARY plural = "Many
 GlotPresses" AND status = 'current' AND project_id = 1`

 ||id||select_type||table||type||possible_keys||key||key_len||ref||rows||Extra||
 ||1||SIMPLE||gp_originals||ref||project_id_status||project_id_status||772||const,const||1||Using
 where||


 `EXPLAIN SELECT * FROM gp_originals WHERE (context IS NULL OR NULL IS
 NULL) AND singular = BINARY "A GlotPress" AND plural = BINARY "Many
 GlotPresses" AND status = 'current' AND project_id = 1`

 ||id||select_type||table||type||possible_keys||key||key_len||ref||rows||Extra||
 ||1||SIMPLE||gp_originals||ref||project_id_status,singular_plural_context||project_id_status||772||const,const||1||Using
 where||

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