Re: Large Files In Profile

2014-06-22 Thread David E. Ross
On 6/22/2014 10:24 AM, EE wrote: > David E. Ross wrote: >> On 6/21/2014 10:34 AM, EE wrote: >>> NoOp wrote: Or no way to effectively clear site preferences: Add Site Preferences option to Clear Private Data (clear stored domain >>

Re: Large Files In Profile

2014-06-22 Thread EE
David E. Ross wrote: On 6/21/2014 10:34 AM, EE wrote: NoOp wrote: Or no way to effectively clear site preferences: Add Site Preferences option to Clear Private Data (clear stored domain settings) Why would you want to clear site permissio

Re: Large Files In Profile

2014-06-21 Thread Geoff Welsh
Ed Mullen wrote: Geoff Welsh pounded out : I figured my netpredictions.sqlite would be huge too, cuz my profile is quite oldbut I don't even have one. GW (same profile since Moz Suite days) Mine is 25.56 Mb. Total profile is 841,828,951 bytes. Bear in mind, that is 8 email accounts and

Re: Large Files In Profile

2014-06-21 Thread Ed Mullen
Geoff Welsh pounded out : A Williams wrote: NoOp wrote: On 06/20/2014 08:00 AM, Robert Kaiser wrote: Rob schrieb: The reason why some of the .sqlite files are so darn large is partly the silly pre-allocation that is done on them. "Silly" is in the eye of the beholder. The preallocation make

Re: Large Files In Profile

2014-06-21 Thread Geoff Welsh
A Williams wrote: NoOp wrote: On 06/20/2014 08:00 AM, Robert Kaiser wrote: Rob schrieb: The reason why some of the .sqlite files are so darn large is partly the silly pre-allocation that is done on them. "Silly" is in the eye of the beholder. The preallocation makes write access to the DB mu

Re: Large Files In Profile

2014-06-21 Thread David E. Ross
On 6/21/2014 10:34 AM, EE wrote: > NoOp wrote: >> On 06/20/2014 08:00 AM, Robert Kaiser wrote: >>> Rob schrieb: The reason why some of the .sqlite files are so darn large is partly the silly pre-allocation that is done on them. >>> >>> "Silly" is in the eye of the beholder. The preallocat

Re: Large Files In Profile

2014-06-21 Thread EE
NoOp wrote: On 06/20/2014 08:00 AM, Robert Kaiser wrote: Rob schrieb: The reason why some of the .sqlite files are so darn large is partly the silly pre-allocation that is done on them. "Silly" is in the eye of the beholder. The preallocation makes write access to the DB much faster. It's a t

Re: Large Files In Profile

2014-06-21 Thread Ron Hunter
On 6/21/2014 3:56 AM, Rob wrote: Robert Kaiser wrote: Rob schrieb: The reason why some of the .sqlite files are so darn large is partly the silly pre-allocation that is done on them. "Silly" is in the eye of the beholder. The preallocation makes write access to the DB much faster. It's a tra

Re: Large Files In Profile

2014-06-21 Thread A Williams
NoOp wrote: On 06/20/2014 08:00 AM, Robert Kaiser wrote: Rob schrieb: The reason why some of the .sqlite files are so darn large is partly the silly pre-allocation that is done on them. "Silly" is in the eye of the beholder. The preallocation makes write access to the DB much faster. It's a t

Re: Large Files In Profile

2014-06-21 Thread Rob
Robert Kaiser wrote: > Rob schrieb: >> The reason why some of the .sqlite files are so darn large is partly >> the silly pre-allocation that is done on them. > > "Silly" is in the eye of the beholder. The preallocation makes write > access to the DB much faster. It's a tradeoff. The vast majority

Re: Large Files In Profile

2014-06-20 Thread »Q«
In , NoOp wrote: > On 06/20/2014 08:00 AM, Robert Kaiser wrote: > > Rob schrieb: > >> The reason why some of the .sqlite files are so darn large is > >> partly the silly pre-allocation that is done on them. > > > > "Silly" is in the eye of the b

Re: Large Files In Profile

2014-06-20 Thread NoOp
On 06/20/2014 08:00 AM, Robert Kaiser wrote: > Rob schrieb: >> The reason why some of the .sqlite files are so darn large is partly >> the silly pre-allocation that is done on them. > > "Silly" is in the eye of the beholder. The preallocation makes write > access to the DB much faster. It's a tra

Re: Large Files In Profile

2014-06-20 Thread EE
David E. Ross wrote: On 6/19/2014 7:21 PM, Larry S. wrote: Doing a profile back-up, and noticed that the folder has become quite a bit larger than in the past. Looking into it, I see three large files that stand out. These are: -- places.sqlite -- webappsstore.sqlite -- n

Re: Large Files In Profile

2014-06-20 Thread Robert Kaiser
Rob schrieb: The reason why some of the .sqlite files are so darn large is partly the silly pre-allocation that is done on them. "Silly" is in the eye of the beholder. The preallocation makes write access to the DB much faster. It's a tradeoff. The vast majority of people have local profiles

Re: Large Files In Profile

2014-06-20 Thread WaltS48
On 06/20/2014 10:36 AM, Ray_Net wrote: David E. Ross wrote, On 20/06/2014 07:53: On 6/19/2014 7:21 PM, Larry S. wrote: Doing a profile back-up, and noticed that the folder has become quite a bit larger than in the past. Looking into it, I see three large files that stand out. These are: --

Re: Large Files In Profile

2014-06-20 Thread Ray_Net
David E. Ross wrote, On 20/06/2014 07:53: On 6/19/2014 7:21 PM, Larry S. wrote: Doing a profile back-up, and noticed that the folder has become quite a bit larger than in the past. Looking into it, I see three large files that stand out. These are: -- places.sqlite -- webappsstor

Re: Large Files In Profile

2014-06-20 Thread David H. Durgee
Rob wrote: Larry S. wrote: Doing a profile back-up, and noticed that the folder has become quite a bit larger than in the past. Looking into it, I see three large files that stand out. These are: -- places.sqlite -- webappsstore.sqlite -- netpredictions.sqlite (the large

Re: Large Files In Profile

2014-06-20 Thread GerardJan
Rob wrote: sqlite3 cookies.sqlite "delete from moz_cookies where name like '\_\_utm%' escape '\'; delete from moz_cookies where expiry < strftime('%s'); vacuum" [gerardjan@gershwin seamonkey]$ sqlite3 cookies.sqlite "delete from moz_cookies where name like '\_\_utm%' escape '\'; delete from

Re: Large Files In Profile

2014-06-20 Thread Rob
Larry S. wrote: > Doing a profile back-up, and noticed that the folder has become quite a > bit larger than in the past. Looking into it, I see three large files > that stand out. These are: > -- places.sqlite > -- webappsstore.sqlite > -- netpredictions.sqlite (the largest by

Re: Large Files In Profile

2014-06-20 Thread Robert Kaiser
David E. Ross schrieb: netpredictions.sqlite is used in a scheme to predict what domains you might request next so that a prefetch to a domain-name server (DNS) can resolve in advance the domain to its IP address. This is supposed to be controlled by the preference variable network.seer.enabled,

Re: Large Files In Profile

2014-06-19 Thread David E. Ross
On 6/19/2014 7:21 PM, Larry S. wrote: > Doing a profile back-up, and noticed that the folder has become quite a > bit larger than in the past. Looking into it, I see three large files > that stand out. These are: > -- places.sqlite > -- webappsstore.sqlite > -- netpredictions.sq

Large Files In Profile

2014-06-19 Thread Larry S.
Doing a profile back-up, and noticed that the folder has become quite a bit larger than in the past. Looking into it, I see three large files that stand out. These are: -- places.sqlite -- webappsstore.sqlite -- netpredictions.sqlite (the largest by far, more than half th