Hi people!! I'm getting problems with a bigger table. I'm doing a query like this:
SELECT field FROM tables WHERE '%.' || somefield LIKE 'somestring' The table has about 500.000 registers. When the table is short, it's too fast, but when it's populated it gets slow. I've been imagined it before. What may I do to optimize this query?? Should an INDEX help me, if it's comparing concatenated strings?? Thank you all, Bruno _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users