1 Reply Latest reply on Sep 15, 2009 11:57 AM by BrendonKoz

    SQLite TRUNCATE in Air?


      I'm looking to truncate my database.  According to SQLite documentation, issuing a "DELETE FROM databaseName" should run a fast truncate.  This does not seem to work within AIR from my tests.  It (the documentation) also states that"The truncate optimization can be permanently disabled for all queries by recompiling SQLite with the SQLITE_OMIT_TRUNCATE_OPTIMIZATION compile-time switch".


      Was this the decision here?  Will I need to copy my table, drop the table, rename the copy, and then run my SQLStatements to do a simple truncate?


      Source: http://www.sqlite.org/lang_delete.html