On 20 Oct 2017, at 7:21pm, jose isaias cabrera <jic...@barrioinvi.net> wrote:
> This takes about 1.5 minutes to run with sqlite v3.20.1 with about 200K > records Can you please time each of the sub-SELECTs ? Do you have any indexes defined on LSOpenJobs ? Can you give LSOpenJobs.cust an affinity of NOCASE ? If so, you do not need the "lower" and can define an index which will speed up the selection. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users