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
