[dba-Tech] FireFox

[Jim Lawrence]

Hi Stuart:

Thanks for the info.

Jim

----- Original Message -----
From: "stuart" <stuart at lexacorp.com.pg>
To: "Discussion of Hardware and Software issues" <dba-tech at databaseadvisors.com>
Sent: Friday, October 28, 2016 6:50:07 PM
Subject: Re: [dba-Tech] FireFox

On looking into it further, you are correct about RowID, it is just an automatic ANPK which is 
included in the definition of any table created without the "WITHOUT ROWID" clause.  

But there was indeed a lot of wasted space, regardless.

Just copied that file to the desktop and did a Compact on it using SQLite manager:
The result was:

The database was compacted using VACUUM statement.
Before compacting:
	Page Count    = 8692
	Database Size = 284819456 bytes
After compacting:
	Page Count    = 5038
	Database Size = 165085184 bytes

That's over 40% reduction in file size.

Interesting discussion of Row IDs and WITHOUT ROWID here:
http://sqlite.org/autoinc.html
and
https://www.sqlite.org/withoutrowid.html


-- 
Stuart

On 28 Oct 2016 at 19:53, Peter Brawley wrote:

> 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
> >
> 
> _______________________________________________
> 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