HI all, I have sqlite database with more than 10000000 records. Here, residencearea is the primary key.
for ex: /country/state/city/village /country/city /country/state/city /country/ country: USA, UK, CHINA Here I want to search based on country and sometimes search based on village and sometimes search based on /country/state/. I tried with fts3 and fts4 virtual tables. Not much performance. like query on direct table, dead slow. Any alternate solution for this? Thanks in advance. Regards, _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users