| commit | 07ce1624de652aa8494630a071b051a1670c4e3d | [log] [tgz] |
|---|---|---|
| author | Dmitri Plotnikov <dplotnikov@google.com> | Wed Nov 25 19:17:05 2009 -0800 |
| committer | Dmitri Plotnikov <dplotnikov@google.com> | Wed Nov 25 19:17:05 2009 -0800 |
| tree | 961d4990cc1bb1d3c3b5bdb06ab7714d0a1d777d | |
| parent | 62cb40bb634b00ab9d8f22b18afed4c44413e9eb [diff] |
Optimizing the email filter query. In order to make the query perform, I had to break out two separate nested queries: one for the email lookup and one for name lookup, and build the UNION of found _ids before retrieving suggestions from the Data table. Performance of the query is improved by orders of magnitude. All tests pass. Bug: http://b/2286776 Change-Id: I0ff20aa2bd3bcfc765831390a36274c01e0e16e3