On 27 May 2014, at 1:58pm, Mike Appenzellar <[email protected]> wrote:

> WHERE some_int_field LIKE 
> other_int_field which is obviously slower. Any thoughts? Both fields are 
> set as integer. Would be be causing this?

Why on earth are you using LIKE to match integers ? It's for strings.  It'll 
work but it's horrible, as you've already found.

What does your lIKE pattern look like ?

Simon.
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to