Re: [sqlite] Problem with EXPLAIN in Sqlite-3.3.5

2006-10-04 Thread drh
"Lowder, Brady M." <[EMAIL PROTECTED]> wrote: > Group, > > Compiling with -DSQLITE_DEBUG=1 has performance impacts as it adds = > other > debug capability that we may not need. I noticed that there is also a > define called SQLITE_OMIT_EXPLAIN in the source code. Is it possible to > just set that

RE: [sqlite] Problem with EXPLAIN in Sqlite-3.3.5

2006-10-04 Thread Lowder, Brady M.
PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, September 29, 2006 2:31 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Problem with EXPLAIN in Sqlite-3.3.5 "Lowder, Brady M." <[EMAIL PROTECTED]> wrote: > Group, > > > Using sqlite-3.3.5 along with Tcl8.4.

RE: [sqlite] Problem with EXPLAIN in Sqlite-3.3.5

2006-09-29 Thread Griggs, Donald
Re: EXPLAIN is omitted by default. Recompile with -DSQLITE_DEBUG=1 to turn it on. That certainly explains it. - To unsubscribe, send email to [EMAIL PROTECTED]

Re: [sqlite] Problem with EXPLAIN in Sqlite-3.3.5

2006-09-29 Thread drh
"Lowder, Brady M." <[EMAIL PROTECTED]> wrote: > Group, > > > Using sqlite-3.3.5 along with Tcl8.4.11 and Tk8.4.11, the EXPLAIN > command doesn't produce the desired result. EXPLAIN is used for > interpreting SELECT, INSERT, DELETE, UPDATE SQL commands. It appears to > be retrieving