Ubuntu 13.04 Suffers Performance

[Patrick Asselman]

On 2013-06-19 21:32, Nils Kassube wrote:
> Basil Chupin wrote:
>> On 19/06/13 17:41, Nils Kassube wrote:
>> > Basil Chupin wrote:
>> >> I did read sometime ago that 'to make Firefox leaner and meaner'
>> >> one
>> >> should clear out the sqlite databases occasionally. The command 
>> to
>> >> do
>> >> this - in console as root, and put command all on the 1 (one) 
>> line:
>> >>
>> >> 
>> Components.classes["@mozilla.org/browser/nav-history-service;1"].ge
>> >> tSe
>> >> 
>> rvice(Components.interfaces.nsPIPlacesDatabase).DBConnection.execu
>> >> teSi mpleSQL("VACUUM");
>> >
>> > Thanks for the command, but I don't understand what it does, so I
>> > won't try it. If I read "executeSimpleSQL("VACUUM")", I fear it
>> > would delete things I want to keep.
>>
>> Well I did this 'vacuuming' a while back and I didn't notice any bad
>> effects. But make a backup of ~/.mozilla of course just in case :-) 
>> .
>
> While I don't expect any nefarious commands from you, I still don't 
> like
> to run an unknown command as root on my main machine. Therefore I 
> tried
> it with an Xubuntu 13.04 Live-CD and this is the result:
>
> xubuntu at xubuntu:~$ sudo su
> root at xubuntu:/home/xubuntu#
> Components.classes["@mozilla.org/browser/nav-history-
> 
> service;1"].getService(Components.interfaces.nsPIPlacesDatabase).DBConnection.executeSimpleSQL("VACUUM");
> bash: syntax error near unexpected token
> `Components.interfaces.nsPIPlacesDatabase'
> root at xubuntu:/home/xubuntu#
>
> Obviously there is something wrong with the command ...
>
> I suppose it is a command to be run within a database program 
> (sqlite?),
> but I'm not familiar with any of them, so I don't even know if that 
> is a
> wrong guess.
>
>
> Nils

Your guess is correct.

It seems that the command rebuilds the databases from scratch, in a 
more or less safe way.

http://www.sqlite.org/lang_vacuum.html

It seems to me that this will only help speed up things if you have 
either an old database that was modified a lot, or a big database with 
lots of entries.

Best regards,
Patrick Asselman