following up on my own response to Dan…
I see what you mean Dan. I am not an expert at reading the query plans, but I
do see that effectively my new query has the same query plan as the last two
queries combined as well as the original query. The only difference is the
order in which it proceed
> On Mar 9, 2020, at 1:04 PM, Dan Kennedy wrote:
>
>
> On 9/3/63 01:44, Puneet Kishor wrote:
>> Update: so, after much hitting of my head against the wall of sql, I came up
>> with the following – as noted above, I really have two distinct set of
>> queries I can do separately like so
>>
>>
On 9/3/63 01:44, Puneet Kishor wrote:
Update: so, after much hitting of my head against the wall of sql, I came up
with the following – as noted above, I really have two distinct set of queries
I can do separately like so
Q1: (SELECT t1Id FROM t1 WHERE …) AS a
Q2: (SELECT t1Id FROM vt1 WHERE
Hi Dan,
> On Sat Mar 7 13:32:54 UTC 2020,Dan Kennedy danielk1977 at gmail.com wrote:
>> On 7/3/63 14:58, P Kishor wrote:
[snipped]
>> The actual query, in this case, takes ~47ms. So far so good. But the problem
>> occurs when I join the two tables
>>
>> ```
>> sqlite> EXPLAIN QUERY PLAN
Update: so, after much hitting of my head against the wall of sql, I came up
with the following – as noted above, I really have two distinct set of queries
I can do separately like so
Q1: (SELECT t1Id FROM t1 WHERE …) AS a
Q2: (SELECT t1Id FROM vt1 WHERE vt1 MATCH ‘bar’) AS b
Then, I can do th
On 7/3/63 14:58, P Kishor wrote:
I asked this question on Stackoverflow with not much success, and a suggestion
to ask it on the list. So here I am. I have two tables, t1(id, t1Id, … other
cols …, fullText) and a FTS5 virtual table vt1(t1Id, fullText)
```
sqlite> EXPLAIN QUERY PLAN
...> S
I asked this question on Stackoverflow with not much success, and a suggestion
to ask it on the list. So here I am. I have two tables, t1(id, t1Id, … other
cols …, fullText) and a FTS5 virtual table vt1(t1Id, fullText)
```
sqlite> EXPLAIN QUERY PLAN
...> SELECT Count(*) as num FROM t1 WHERE d
7 matches
Mail list logo