Greetings! 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?
sqlite> ATTACH 'L:\Data\OpenJobsTool\Selva.Shared.DB.UK.AllOpenProjs.db' AS client; sqlite> sqlite> explain ...> SELECT ls.id FROM LSOpenProjects ls JOIN client.LSOpenProjects cl ON ...> ( ...> cl.login != 'lsuser' AND ...> cl.id = ls.id AND ...> cl.XtraB != ls.XtraB ...> ) LIMIT 100; addr opcode p1 p2 p3 p4 p5 comment ---- ------------- ---- ---- ---- ------------- -- ------------- 0 Init 0 17 0 00 Start at 17 1 Integer 100 1 0 00 r[1]=100; LIMIT counter 2 OpenRead 2 403349 2 k(4,,,,) 00 root=403349 iDb=2; Proj_id_login_XtraB 3 OpenRead 0 5 2 47 00 root=5 iDb=2; LSOpenProjects 4 Rewind 2 16 2 0 00 5 Column 2 1 2 00 r[2]=LSOpenProjects.login 6 Eq 3 15 2 (BINARY) 51 if r[2]==r[3] goto 1 5 7 IdxRowid 2 4 0 00 r[4]=rowid 8 SeekRowid 0 15 4 00 intkey=r[4]; pk 9 Column 2 2 5 00 r[5]=LSOpenProjects.XtraB 10 Column 0 46 6 00 r[6]=LSOpenProjects.XtraB 11 Eq 6 15 5 (BINARY) 51 if r[5]==r[6] goto 1 5 12 Copy 4 7 0 00 r[7]=r[4] 13 ResultRow 7 1 0 00 output=r[7] 14 DecrJumpZero 1 16 0 00 if (--r[1])==0 goto 16 15 Next 2 5 0 01 16 Halt 0 0 0 00 17 Transaction 2 0 597 0 01 usesStmtJournal=0 18 String8 0 3 0 lsuser 00 r[3]='lsuser' 19 Goto 0 1 0 00 sqlite> _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
