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 <kit.sa...@gmail.com> wrote: > 2011/12/27 Durga D <durga.d...@gmail.com>: > > 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 > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users