"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 define properly (I assume to undefine it or perhaps set it > to 0) to enable the EXPLAIN capability without the overhead of the > -DSQLITE_DEBUG=1 method? > > Anyone know what the proper setting for SQLITE_OMIT_EXPLAIN should be on > the commend line? >
Why do you want EXPLAIN if you are not debugging? The opcodes change (sometimes drastically) from one point release to the next? What possible use could you have for EXPLAIN that is performance critical? -- D. Richard Hipp <[EMAIL PROTECTED]> ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
