Hi kit,
Thanks for your response.
CREATE VIRTUAL TABLE virfts4 using fts4(residence, arrivtime, duration,
imagelocation);
insert into virfts4 values('/country1/state1/city1/village1', 0730, 1500,
'C');
insert into virfts4 values('/country1/state1/city1/village2', 0731, 1500,
'C');
insert into virfts4 values('/countr1/state1/village1/', 1800, 1000, 'D');
select * from virfts4 where residence match '/*'; -- dint work
how to get counties names from this db by using query?
select * from virfts4 where residence match '/c*'; -- it's worked and very
fast.
Thanks in advance.
On Tue, Dec 27, 2011 at 2:01 PM, Kit <[email protected]> wrote:
> 2011/12/27 Durga D <[email protected]>:
> > HI all,
> > I have sqlite database with more than 10000000 records. Here,
> > residencearea is the primary key.
> > /country/state/city/village
> > I tried with fts3 and fts4 virtual tables. Not much performance.
> > like query on direct table, dead slow.
>
> Send your SQL query and table structure.
>
> Maybe you used LIKE instead of MATCH.
> --
> Kit
> _______________________________________________
> sqlite-users mailing list
> [email protected]
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
