On Mon, 15 Feb 2016 10:57:29 +0100 Michele Pradella <michele.pradella at selea.com> wrote:
> Sorry you are right, the test I did was with % not with a *....just a > cut and paste error > Anyway it's tricky because I have to tell sqlite which index to use > in LIKE to fast search but I do not have to tell the index if start > with % or _ because otherwise the query is not executed.. I'll handle > it... I have read the thread and still don't know what's your LIKE expression to search. If you know something about the string, you can use this tricks: a) If you search for '%552', any string that ends with '552', you can create an index over reverse plate string and use that index, b) If you search for '_552_' where the number of '_' before and after '552' are always the same (so, '552' begins at the same position on every plate), create a similar index to a) case, but rotating the letters on the string instead reversing it. You know your data structure and the queries, perhaps other data transforms may create better indexs > Selea s.r.l. > > > Michele Pradella R&D --- --- Eduardo Morras <emorrasg at yahoo.es>
