On 15 Jun 2011, at 4:55am, Hoang Linh Duong wrote: > It is a good idea to divide into a sector. I will try that. But according to > your suggestion, using LIKE is not advisable, since if i create an index > (category, sector), this index will not be applicable for LIKE.
I am not sure whether with both clauses (category and sector) the SQLite engine will correctly use the index. But since it involves no change to your program you might try it, and see whether having the index in the database speeds up the search. If it does not, you can simply delete the index. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users