X
Tap here to go to the mobile version of the site.

Support Forum

how do I prevent or limit these huge *.sqlite files?

Posted

Firefox litters its working directories with ever bigger files ending in .sqlite. Right now it has a 40MB urlclassifier3.sqlite file. What are these files, and why do they need to be so big? How can I reduce their size or limit their growth? Presumably just deleting them will cause mayhem?

Firefox litters its working directories with ever bigger files ending in .sqlite. Right now it has a 40MB urlclassifier3.sqlite file. What are these files, and why do they need to be so big? How can I reduce their size or limit their growth? Presumably just deleting them will cause mayhem?

Chosen solution

Hello,

  • urlclassifier.sqlite contains the site information for the phishing / malware protection. 
  • places.sqlite for example contains your bookmarks and recent history.

However, urlclassifier.sqlite shouldn't be that big. Maybe it could help if you simply delete the file and restart Firefox. It should be recreated on next start.

Cheers,

Tobbi

Read this answer in context 1

Additional System Details

Installed Plug-ins

  • nspluginwrapper is a cross-platform NPAPI plugin viewer, in particular for linux/i386 plugins.This beta software is available under the terms of the GNU General Public License.
  • The Adobe Reader plugin is used to enable viewing of PDF and FDF files from within the browser.

Application

  • User Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.2.11) Gecko/20101028 Red Hat/3.6-2.el5 Firefox/3.6.11

More Information

user66338 58 solutions 452 answers

Chosen Solution

Hello,

  • urlclassifier.sqlite contains the site information for the phishing / malware protection. 
  • places.sqlite for example contains your bookmarks and recent history.

However, urlclassifier.sqlite shouldn't be that big. Maybe it could help if you simply delete the file and restart Firefox. It should be recreated on next start.

Cheers,

Tobbi

<p>Hello,</p> <ul> <li><em>urlclassifier.sqlite</em> contains the site information for the phishing / malware protection.&nbsp;</li> <li><em>places.sqlite</em> for example contains your bookmarks and recent history.</li> </ul> <p>However, urlclassifier.sqlite shouldn't be that big. Maybe it could help if you simply delete the file and restart Firefox. It should be recreated on next start.</p> <p>Cheers,</p> <p>Tobbi</p>

Question owner

Splendid! Thanks, Jeroen

Splendid! Thanks, Jeroen
eingram 0 solutions 1 answers

I can't find the file by searching my computer. I have Windows 7 Pro version. Does anyone know where this file is stored? I know my file is large because I use Carbonite online backup and it showed urlclassifier3.sqlite as being 184 mb when it backed it up

I can't find the file by searching my computer. I have Windows 7 Pro version. Does anyone know where this file is stored? I know my file is large because I use Carbonite online backup and it showed urlclassifier3.sqlite as being 184 mb when it backed it up
the-edmeister
  • Top 10 Contributor
  • Moderator
4080 solutions 30767 answers

Un-hide the hidden files and folders.

Not sure about Win7 or Vista, but on W2K & WinXP this is the path to that setting.
Control Panel > Folder Options > View - Advanced Settings

Un-hide the hidden files and folders. Not sure about Win7 or Vista, but on W2K & WinXP this is the path to that setting. <br /> Control Panel > Folder Options > View - Advanced Settings
d_vdlinden 0 solutions 1 answers

Helpful Reply

I Upgraded from 3.6.15 to 4.0. This resulted in an increase in size op places.sqlite to 10MB+. Originally it was about 1MB. The biggest problem is not the actual new size, but the fact the profile is stored in my windows profile area. Especially in working environments the windows profile size is limited, as in my case. A 10MB file is a large chunk of a 30MB windows profile.

I see two possible solution: 1. Be able to move your profile outside the windows profile; or 2. Reduce the minimal filesize of places.sqlite

Thanks for the help............

I Upgraded from 3.6.15 to 4.0. This resulted in an increase in size op places.sqlite to 10MB+. Originally it was about 1MB. The biggest problem is not the actual new size, but the fact the profile is stored in my windows profile area. Especially in working environments the windows profile size is limited, as in my case. A 10MB file is a large chunk of a 30MB windows profile. I see two possible solution: 1. Be able to move your profile outside the windows profile; or 2. Reduce the minimal filesize of places.sqlite Thanks for the help............
Tolan 0 solutions 1 answers

Helpful Reply

I have the same problem. Just upgraded to 4.0 from 3.x and "places.sqlite" jumped from ~1MB to 10MB. Tried to vacuum it but says the "file is encrypted or is not a database". I am only allowed 30MB for the profile and now if I can't solve this then I will have to either go back to 3.x or uninstall Firefox and stick with IE, which I don't want to do!

I have the same problem. Just upgraded to 4.0 from 3.x and "places.sqlite" jumped from ~1MB to 10MB. Tried to vacuum it but says the "file is encrypted or is not a database". I am only allowed 30MB for the profile and now if I can't solve this then I will have to either go back to 3.x or uninstall Firefox and stick with IE, which I don't want to do!