For Fx2, the urlclassifier2.sqlite never got bigger than 10M even after months, but now the urlclassifier3.sqlite in Fx3 RC1 gets to over 90M under weeks. I wonder if there's any settings about this, or any option to purge the file? thanks.

wellofsouls wrote:For Fx2, the urlclassifier2.sqlite never got bigger than 10M even after months, but now the urlclassifier3.sqlite in Fx3 RC1 gets to over 90M under weeks. I wonder if there's any settings about this, or any option to purge the file? thanks.

wellofsouls wrote:For Fx2, the urlclassifier2.sqlite never got bigger than 10M even after months, but now the urlclassifier3.sqlite in Fx3 RC1 gets to over 90M under weeks. I wonder if there's any settings about this, or any option to purge the file? thanks.

One of my users' urlclassifier2.sqlite file grew to 775GB (yes, GB, that's not a typo) in one day yesterday. We discovered it when our nightly incremental backup suddenly reported that it was going to take 46 hours to complete.

I'd say there's a problem.

I've seen one other report of these files growing to several hundred gigs, but it's on the members-only paysite experts-exchange.com, so I couldn't see what the resolution was.

wellofsouls wrote:For Fx2, the urlclassifier2.sqlite never got bigger than 10M even after months, but now the urlclassifier3.sqlite in Fx3 RC1 gets to over 90M under weeks. I wonder if there's any settings about this, or any option to purge the file? thanks.

The new database isn't merely handling "another kind" of bad site (it's WAY more comprehensive). But WoS, I think that you SHOULD delete the file from your profile (while Firefox is NOT running). And do that AFTER updating from RC1 to "final". There weren't any changes affecting phishing/malware DB operations between RC2 and Final, but IIRC there were changes between RC1 and RC2. The correct size is only about 54MB, and erasing it will allow the new file to be built "properly". If you've been using Firefox "Beta" or "Nightly" versions from even earlier than RC1, there could be quite a lot of "grunge" from older implementations, doing absolutely nothing except consuming disk space.

As for the 54 megabytes-- I agree, it's a little odd that the DB is bigger than an entire install of something like Norton Internet Security (including all the programs, and Norton does much more-- Firewall, email scanning, disk scanning, etc.). I'm not saying that I like NIS, not at all-- but the humongous size of the DB is kinda surprising. Still, yours (at 90+MB) is definitely not right, you're nearly double what it should take.

Make a fire FOR a man, he'll be warm for the rest of the night. Set a man ON fire, he'll be warm for the rest of his life!

I found this forum just looking for info on urlclassifier3.sqlite. I had noticed that "Sweepi" a free cleanup application from http://sweepi.yooapps.com/?l=E takes a while (maybe 45 seconds) sometimes to delete it. I gather fro the entries in this forum that deleting it hurts nothing and in fact is a really good idea. So is this program, I've been using it daily with XP for quite a while with no ill effects. Solves this problem, that's for sure

You really shouldn't use unknown apps--or any unnecessary 3rd party app--for maintenance--and certainly not just to delete a file. The correct size, as all agree, is about 55 MB. Delete it ONCE and that should be all you ever have to do. If it isn't, then something is wrong, and you have something else tinkering around with that file that shouldn't be there. If you really want to bother, there is also a sqlite utility that will "vacuum" the file and compact it by roughly 2 x. But I wouldn't use that if the file isn't already the correct size.