MozillaZine

storage.vacuum.last parameters

User Help for Seamonkey and Mozilla Suite
webmoebius
 
Posts: 238
Joined: January 21st, 2007, 12:52 pm

Post Posted May 6th, 2019, 3:49 pm

I noticed that within Seamonkey about:config parameters, there are the two parameters of:

storage.vacuum.last.index
storage.vacuum.last.places.sqlite

Can someone tell me what these parameters are for? In a slightly related matter, I recall there was a VACUUM command that could be used somehow to perform maintenance on the places.sqlite SQL database, but I don't quite have the correct syntax / procedure to use it. I believe it was to be executed in the Seamonkey error console.

To date I have always used SQLite Manager 0.83 extension to compact SQL databases in SM and this works with Firefox-ESR 52.9 as well. However, starting with Firefox-ESR 60.X releases, that SQL-Lite Manager extension is no longer compatible with FF to run maintenance on SQLite databases so I am also looking for another similar solution as an extension install for this purpose.

therube

User avatar
 
Posts: 20002
Joined: March 10th, 2004, 9:59 pm
Location: Maryland USA

Post Posted May 8th, 2019, 11:43 am

FF should vacuum itself, periodically.
You can use SQLite to manually vacuum.

SQLITE.vacuum.bat:
Code: Select all
dir  *.sqlite  >  b4.sqlite.vacuum.TXT
echo "-------" >> b4.sqlite.vacuum.TXT

for  %%i in (*.sqlite) do (sqlite3.exe %%i vacuum)

dir  *.sqlite  >> b4.sqlite.vacuum.TXT

pause
exit

:: also if you sqlite3.exe {filename}
::         you can type "VACUUM;"  at
::         the prompt & it will do it
::         interactively



(If you're actually using FF 53, you'd be far better off, security-wise, using 52.9 ESR instead.)
Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US; rv:1.9.1.19) Gecko/20110420 SeaMonkey/2.0.14 Pinball CopyURL+ FetchTextURL FlashGot NoScript

webmoebius
 
Posts: 238
Joined: January 21st, 2007, 12:52 pm

Post Posted May 13th, 2019, 4:28 am

Thanks for that Windows batch file code. I guess the part that I'm not sure about is where does the executable file SQLITE3.EXE come from and where would I obtain that file? I actually do recall that I read some time ago that the VACUUM function does automatically take place occasionally on SM and FF, but I would prefer to be able to initiate it manually on command. I'm not even sure what criteria / condition triggers the auto vacuum function.

As for the browser I'm using to post to this thread, it's actually Seamonkey 2.49.4, with a USER AGENT string manual override whose purpose was to deal with a particular web site that I need it for regularly. I do in fact have Firefox-ESR 52.9 installed, which is the last available version compatible on this computer's operating system version, though I have recently set up Firefox-ESR 60.6 on another computer with a later version of Windows. I only use FF-ESR releases and not usually the general consumer releases.

therube

User avatar
 
Posts: 20002
Joined: March 10th, 2004, 9:59 pm
Location: Maryland USA

Post Posted May 15th, 2019, 4:56 am

where does the executable file SQLITE3.EXE come from and where would I obtain that file?

Linked above -> Downloads.
(After that, sqlite3.exe has to be somewhere where it can be found or pointed to, so like in your %PATH%, or in the current directory that you're running the vacuum from, or...)

manual override whose purpose was to deal with a particular web site that I need it for regularly

Might be better to set an individual override for that particular website.
Code: Select all
general.useragent.override.partcularwebsite.com;Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:99.9) Gecko/20190201 Surelyyoujest/99.9
Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US; rv:1.9.1.19) Gecko/20110420 SeaMonkey/2.0.14 Pinball CopyURL+ FetchTextURL FlashGot NoScript

Return to SeaMonkey Support


Who is online

Users browsing this forum: No registered users and 1 guest