Re: SQLite and SELECT WHERE local_relpath LIKE

Philip Martin <philip.martin_at_wandisco.com> writes:

> I need something like
>
> local_relpath = 'zig1/zag27
> OR (local_relpath > 'zig1/zag27/' AND local_relpath < 'zig1/zag270')
>
> and that is as slow as LIKE. Adding that "local_relpath =" is the
> problem, without it I get the children in 0.006s. With it I get the
> path and the children but it takes 0.35s.

SQL is tricky: I can run a query using either

      local_relpath = 'zig1/zag27

or using

     local_relpath > 'zig1/zag27/' AND local_relpath < 'zig1/zag270'

and it takes 0.006s, but if I put in both parts in together with OR it
takes 0.35s. That's 2 orders of magnitude! I suppose I will have to
try using EXPLAIN.

-- 
Philip