Open the database file with sqlite3 and use the "vacuum;" command. This will deflate unused space.
Am Samstag, 16. Januar 2016, 11:15:25 schrieb zero: > Hello, > > I just migrated my SQLite database. > It was 33 MB before. After migration it is 57 MB big. > > Is it OK ? > Is there a way to keep the previous smaller size ? > > As I am using a Box account to be synchronized between machines, the > smaller the database is, the faster the synchronisation is. > > (I know the next step is to use mySQL instead... by the way do you know > some free or cheap (1€ / month) hosting solution ?) > > Bye > > Le 07/12/2015 20:33, OLiver Eichler a écrit : > > Hi, > > > > with commit 1aa88bc0fd78f20c7907d7fc59f3ff15e507fcd0 the internal database > > format changed significantly. QMapShack will migrate your database. After > > the migration the database won't be compatible with older versions. > > > > I strongly recommend to backup your database prior to migration! > > > > Please test! I did my best to verify the change, but there is still a > > chance for bugs. And the sooner we find them, the better. > > > > Thanks > > > > Oliver > > > > -------------------------------------------------------------------------- > > ---- Go from Idea to Many App Stores Faster with Intel(R) XDK > > Give your users amazing mobile app experiences with Intel(R) XDK. > > Use one codebase in this all-in-one HTML5 development environment. > > Design, debug & build mobile apps & 2D/3D high-impact games for multiple > > OSs. http://pubads.g.doubleclick.net/gampad/clk?id=254741911&iu=/4140 > > _______________________________________________ > > Qlandkartegt-users mailing list > > Qlandkartegt-users@lists.sourceforge.net > > https://lists.sourceforge.net/lists/listinfo/qlandkartegt-users > > --- > L'absence de virus dans ce courrier électronique a été vérifiée par le > logiciel antivirus Avast. https://www.avast.com/antivirus > > > ---------------------------------------------------------------------------- > -- Site24x7 APM Insight: Get Deep Visibility into Application Performance > APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month > Monitor end-to-end web transactions and take corrective actions now > Troubleshoot faster and improve end-user experience. Signup Now! > http://pubads.g.doubleclick.net/gampad/clk?id=267308311&iu=/4140 > _______________________________________________ > Qlandkartegt-users mailing list > Qlandkartegt-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/qlandkartegt-users ------------------------------------------------------------------------------ Site24x7 APM Insight: Get Deep Visibility into Application Performance APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month Monitor end-to-end web transactions and take corrective actions now Troubleshoot faster and improve end-user experience. Signup Now! http://pubads.g.doubleclick.net/gampad/clk?id=267308311&iu=/4140 _______________________________________________ Qlandkartegt-users mailing list Qlandkartegt-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/qlandkartegt-users
