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
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
