[dba-Tech] FireFox

[Peter Brawley]

On 10/28/2016 18:50, Stuart McLachlan wrote:
> The table in my  FF webappsstore.sqlite  database has 29798 rows but the maximum RowID
> is 74255, so it certainly looks as though it could do with "Conpact".
No no no, rowID is just an auto_increment value, a value of 74255 with a 
rowcount of 29798 does /not/ mean there are 44k rows of dead space---the 
diff between 74255 and 29798 is purely logical, it has no impact 
whatever on physical disk usage or on performance.

PB

------

> Looks to me like poor  programming to not include periodic db cleanup.
>
>
>
> On 28 Oct 2016 at 10:31, John R Bartow wrote:
>
>> A few version ago Ccleaner added the option to compress Firefox's
>> database as part of it's cleanup routine. The db muct get a little
>> bloated when used by FF. (?)
>>
>> -----Original Message-----
>> From: dba-Tech [mailto:dba-tech-bounces at databaseadvisors.com] On
>> Behalf Of Jim Lawrence Sent: Thursday, October 27, 2016 12:18 PM To:
>> Discussion of Hardware and Software issues Subject: [dba-Tech] FireFox
>>
>> Hi All:
>>
>> Does everyone already know this or is it just me, that the following
>> amazing?
>>
>> I have just discovered that FireFox is built on top of a series of
>> SQLite files. Every plugin, setting, history, download, cookie, visted
>> site, caches and bookmarks are all stored in these database files. All
>> tranaction date, size, duration, activity and location is stored in
>> the records. If you lose some information and wish to trace it just
>> dig through these files. Mind you, if you have been using your version
>> of FF for more than a couple weeks, the files are huge and date ranges
>> are the only way to find anything usable (50 pages of data is
>> useless)...spent hours last night trying to find details on a couple
>> of visited site (and was learning how SQLite works).
>>
>> I have not tried to use other SQLs to access the data as I suspect
>> SQLite has it own data encoding. I was working at the command prompt
>> for quite a while before I downloaded a GUI. Has anyone else had
>> experience with SQLite? If you have do you have any comments or
>> recommendations?
>>
>> TIA
>> Jim
>> _______________________________________________
>> dba-Tech mailing list
>> dba-Tech at databaseadvisors.com
>> http://databaseadvisors.com/mailman/listinfo/dba-tech
>> Website: http://www.databaseadvisors.com
>>
>> _______________________________________________
>> dba-Tech mailing list
>> dba-Tech at databaseadvisors.com
>> http://databaseadvisors.com/mailman/listinfo/dba-tech
>> Website: http://www.databaseadvisors.com
>>
>
> _______________________________________________
> dba-Tech mailing list
> dba-Tech at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-tech
> Website: http://www.databaseadvisors.com
>