Hi, Joseph, On Sun, Sep 1, 2013 at 6:21 PM, Joseph L. Casale <jcas...@activenetwerx.com>wrote:
> > Hi, > > Can you do "DESCRIBE QUERY PLAN <your_query>" and post results here? > > > > Also, what do you mean by "unbearable at scale"? Did you measure it? What > > is the result? > > > > Thank you. > > It doesn't finish with maybe 4 or 5 hours run time. > > Sorry, do you mean "explain query plan ..."? > 0 0 1 SCAN TABLE d_table_b AS da (~100000 rows) > Is this the index you referenced in you reply to Simon? Maybe you are using wrong index/column? I had the same problem (kind of) and got the answer here to create a different index... Thank you. Can you post you schema? > 0 1 3 SEARCH TABLE d_table_a AS d USING INTEGER PRIMARY > KEY (rowid=?) (~1 rows) > 0 2 0 SEARCH TABLE s_table_b AS sa USING AUTOMATIC > COVERING INDEX (key=?) (~7 rows) > 0 3 2 SEARCH TABLE s_table_a AS s USING INTEGER PRIMARY > KEY (rowid=?) (~1 rows) > > Thanks, > jlc > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users