Archive | Multi Database RSS feed for this section

Pensamento rápido – “ilike” SQL

4 Sep

Today I saw a post at one of the blogs I often watch, where a guy said he got 1000% of speed boost in a aplication by changing: uma aplicação trocando um: SELECT * FROM table WHERE fieldname ILIKE ‘abc%’; For SELECT * FROM table WHERE lower(fieldname) LIKE ‘abc%’; (changed ilike to lower … like) […]