hello,
I have a question about fts4 model , could you help me please ?
I have two virtual tables , these are created by fts4 , I have no idea
how to improve the query efficiency when i execute a nested query ,for example:
I found that the first case is better than another one.
case1:
select a.*, b.Photo from shop as a, Brand as b where a.Brand in (select Name
from Brand where Brand Match ?restaurant?)
case2:
select a.*,b Photo from shop as a, Brand as b where b.Brand match ?restaurant?
and match a.Brand = b.Name
which ones may affect the efficiency ?
Is there any other way better?
I?ve participated in sqlite fts4 for only 1 months. there are seldom statistics
to get in China.
best regards
thanks
