The EXPLAIN QUERY PLAN keyword works, and I love it, but it's completely undocumented. How come?
On 9/19/08, Stephen Oberholtzer <[EMAIL PROTECTED]> wrote: > On Fri, Sep 19, 2008 at 12:36 PM, Giuseppe Costanzi > <[EMAIL PROTECTED]>wrote: > >> >> How could improve my code? > > > Go into the sqlite3 command line and issue > > EXPLAIN QUERY PLAN <example select statement> > > You'll have to fill in some values for the ?s, but that'll give you some > hints. > > > Also: How long is "too slow"? Several seconds? > > > -- > -- Stevie-O > Real programmers use COPY CON PROGRAM.EXE > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Seun Osewa http://www.nairaland.com/ _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users