WelcomeWelcome | FAQFAQ | DownloadsDownloads | WikiWiki

Author Topic: Vacuum your Firefox 3  (Read 2806 times)

Offline bmarkus

  • Administrator
  • Hero Member
  • *****
  • Posts: 7183
    • My Community Forum
Vacuum your Firefox 3
« on: May 02, 2011, 05:48:36 AM »
Looking for some information on SQLite by accident found this interesting article:

http://www.gettingclever.com/2008/06/vacuum-your-firefox-3.html

It may help to reduce backup size and improve performance, worth to try. What you need is sqlite3-bin.tcz extension.
Béla
Ham Radio callsign: HA5DI

"Amateur Radio: The First Technology-Based Social Network."

Offline tinypoodle

  • Hero Member
  • *****
  • Posts: 3857
Re: Vacuum your Firefox 3
« Reply #1 on: May 02, 2011, 12:52:36 PM »
Not using any netscape based browser myself since long, but when using hv3 which can store all its settings in one single sqlite file, if I run a vacuum script before backup then backup will definitely end up with a reduced size.
Code: [Select]
#!/bin/sh
for f in /home/tc/.local/share/data/hv3/hv3_state.db; do sqlite3 $f VACUUM; done
"Software gets slower faster than hardware gets faster." Niklaus Wirth - A Plea for Lean Software (1995)

Offline tinypoodle

  • Hero Member
  • *****
  • Posts: 3857
Re: Vacuum your Firefox 3
« Reply #2 on: May 16, 2013, 05:17:45 PM »
For a script which is automatically optimizing all sqlite databases in rootfs see here:

http://forum.tinycorelinux.net/index.php/topic,15399.msg89188.html

"Software gets slower faster than hardware gets faster." Niklaus Wirth - A Plea for Lean Software (1995)