Using FTS3/4 Table based on Select Statements from Normal Table
<p>In my app, I'm developing in Android, I have a Sqlite Table called <em>Transactions</em>, with these fields:</p>

<pre><code>_Id | Date | Value | Notes
</code></pre>

<p>I already have a ListView showing results filtering by  Date (for example): </p>

<p><code>Select * FROM Transacions WHERE Date BETWEEN '2016-04-25' AND '2016-05-14'</code></p>

<p>It works fine, but I want to implement a SearchView to search transactions between a custom date have in field <em>Notes</em>, some text typed in SearchView.
I read about adding a SearchView, and the best way to implement to search is using a FTS3 or FTS4 Table, allowing the user, for example, type "SUPERMARKET" and find a Transaction where the Notes have this text.
The problem appears because a FTS table is slow to perform WHERE conditions (like the above, to filter date)...</p>

<p>How can I implement both Filtering date, using <code>WHERE date BETWEEN ... and ...</code>, and filtering text Notes with the performance of a FTS Table?</p>

<ul>
<li>If it is not possible to do so, is it a good idea to have a query like this:</li>
</ul>

<p><code>Select * FROM Transacions WHERE (Date BETWEEN '2016-04-25' AND '2016-05-14) AND Notes LIKE '%text%''</code>?</p>