[dba-Tech] FireFox

[Peter Brawley]

On 10/28/2016 0:15, Jim Lawrence wrote:
> Why does SQLite start to slow down? That suggests there are some serious flaws with that DB...

Agreed. I think it was designed as a beginner's sql tool. it doesn't 
scale. How the Mozilla people talked themselves into building FF around 
it, I dunno.

PB


> how can that be. Do you have any docs on the subject? If I clear the FF database tables will FF speed and responsiveness improve?
>
> Jim
>
> ----- Original Message -----
> From: "Peter Brawley" brawley at earthlink.net>
> To: "Discussion of Hardware and Software issues" databaseadvisors.com>
> Sent: Thursday, October 27, 2016 7:31:16 PM
> Subject: Re: [dba-Tech] FireFox
>
> On 10/27/2016 12:17, Jim Lawrence wrote:
>> 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?
> SQLite bloat and the slowness it causes were some of the reasons I gave
> up on FF.
>
> PB
>
>> 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
>