On 20 Oct 2017, at 7:21pm, jose isaias cabrera <[email protected]> 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 [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
