On 17 Aug 2017, at 4:36am, jose isaias cabrera <jic...@barrioinvi.net> wrote:
> The following query is taking a bit too long for my taste. I did a quick > query with explain and I got this... Anything I can do to make it faster? > Yes, I know I need to do some major work on rearranging, but anything else? Can you post again with just the SELECT command, and any indexes you have on either table ? The solution is probably going to involve making an index which ideally suits the SELECT command. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
