TapForms_db.sqlite

Viewing 3 reply threads
  • Author
    Posts
  • June 28, 2010 at 9:09 PM #3175

    Anonymous
    Inactive

    Hello,

    Can be a solution to resolve certain slowness to see corruption of the file ” TapForms_db.sqlite ” is he(it) possible to include the command(order) “Vacuum” of sqlite to compress and clean the base?

    It is just a suggestion.

    June 29, 2010 at 7:44 AM #4122

    Brendan
    Keymaster

    Hello Bidule,

    When you import a CSV file, I perform an ANALYZE command on the whole database at the end of the import process. I thought about adding VACUUM, but that might take a long time, so I didn’t. I may add something to the Tools area called “Database Maintenance” which will perform the ANALYZE and VACUUM and possibly a REINDEX. Although I think if you VACUUM, the other things aren’t necessary. Not sure.

    Anyway, that’s for a future update hopefully.

    Thanks,

    Brendan

    November 13, 2010 at 8:11 AM #4256

    Steved
    Participant

    I use SQLite Manager for fire fox. Go to your App’s in iTunes, Go down to file sharing. Use “save to” to save a copy of your database. Open it with SQLite in firefox VACUUM it and put it back.

    November 13, 2010 at 8:14 AM #4257

    Brendan
    Keymaster

    I’ve added a Database Maintenance function to the Tools screen which will let you perform a vacuum, reindex, analyze, and rebuild the search index. Available in the next update.

    Brendan

Viewing 3 reply threads

You must be logged in to reply to this topic.