View Single Post
Old 10-11-2015, 07:56 AM   #116 (permalink)
oliver1071
Registered Users
 
Posts: 4,707
 

Join Date: Mar 2011
Default

Quote:
Originally Posted by LinusLarsson View Post
Small bugfix release v3.0.1. Only change is the weekly graph now funtioning correctly

Download at homepage
http://www.linlar.org/vbc

/Linus
Looks great all fixed for me.

Not sure if anyone is crazy like me with databases being clean. But I've been adding and removing a lot in the analyzer so I wanted to see about compacting the database. Just preparing for the years of use this application is going to get.
I'm sure with the small amount of data in here it's probably not even needed. But I just loaded some huge images in before I thought about how it would affect the size so I wanted to compact after replacing them with smaller ones.

SQLite is pretty simple and the command line shell can be downloaded from here http://sqlite.org/download.html

Running the following command with the path to my database chopped a couple megs off of the size of the database.

sqlite3 C:\Users\admin\.vcontrol.db "VACUUM FULL;"

Description of the command:
The VACUUM command cleans the main database by copying its contents to a temporary database file and reloading the original database file from the copy. This eliminates free pages, aligns table data to be contiguous, and otherwise cleans up the database file structure.
The VACUUM command may change the ROWID of entries in tables that do not have an explicit INTEGER PRIMARY KEY. The VACUUM command only works on the main database.
__________________
__________
Goblin 380, 500, 570, Mikado 690SX, 480Xx(Stretched 500) , Protos Mini, Max V2 , Oxy 3, Vbar Control/Neo Vlink (Citizen 758)YouTubeProgress:http://tinyurl.com/oliver1071
oliver1071 is offline        Reply With Quote