On Thu, Jun 28, 2007, Mark Hatle wrote: > Is "TEMPORARY TABLE" something special? I knew about the :memory: > before, but not the other.
Excerpt from http://www.sqlite.org/lang_createtable.html: If the "TEMP" or "TEMPORARY" keyword occurs in between "CREATE" and "TABLE" then the table that is created is only visible within that same database connection and is automatically deleted when the database connection is closed. Any indices created on a temporary table are also temporary. Temporary tables and indices are stored in a separate file distinct from the main database file. > Otherwise this looks good to me. It may even speed things up slightly. But before I can commit I at least wish to find a better approach for the DB_PRIVATE value. The current hack is not the best since sliced bread: > > +#if defined(WITH_SQLITE) && !defined(DB_PRIVATE) > > +#define DB_PRIVATE 0x0200000 /* shameless hack for shared option */ > > +#endif Ralf S. Engelschall [EMAIL PROTECTED] www.engelschall.com ______________________________________________________________________ RPM Package Manager http://rpm5.org Developer Communication List rpm-devel@rpm5.org