Some of my friends who use Google Maps on a regular (and a bit abusive ) basis (few hours a day) complained of performance issues.
I found out that Avast collects all URLs into URL.db and at startup it loads this file into memory. Since every zooming and panning you do on Maps will be transformed into a unique URL, the user generates thousands of URLs a day. Thus the URL.db file is huuuuge. In just a couple of months it grew to over 500 MB, but there were cases of 1.8 GB sized files, too. This resulted into intense HDD and RAM usage. Even where there is enough RAM, HDD will be used for reading in the contents of the file.
Deleting the file is just a temporary fix.
What is the definite fix for this?
Thanks!
PS: I want to disable only the (sub)component that is guilty.
OK I have just found it in my XP Pro system
C:\Documents and Settings\All Users\Application Data\AVAST Software\Avast\URL.db
Or C:\ProgramData\AVAST Software\Avast\URL.db in later OSes
But it is no where near the size yours is. Mine is a little over 38MB, even so that is relatively large, it was created on 1 December 2015 and last modified today. On my win7 netbook which isn’t so heavily used it is only 8.4MB and on my Win10 laptop it is only just over 6MB (but this is only 10 days old).
I’m not sure exactly what this is used for, at first I thought it could be related to checking DNS locations to confirm them. But why they could grow to that size is not good housekeeping.
Hello,
thank you very much for reporting such possible regression. We will investigate further. In the meantime, could I ask you, csabi98, for sending us support package (and posting the file ID here)?
@csabi98:
I tried to reproduce the behavior using custom web (and google maps) crawler. After letting it run for several days, the url.db did grow, but only up to few MB, so I am not able to reproduce the behavior you described. Anyway, it would really help us, if you could upload the big url.db file (and stadard avast support package) to our FTP for further analysis (once it grows in size again). Don’t forget to post the File ID here so we can find it. Thank you in advance!
I noticed the start of this thread was way back in 2016, so are Avast still looking at it?
I have checked both my XP and Win10 machines. XP has 3 files of which URL.db is just 9.90Mb.
Win10 machine has more and bigger files. See attachment.
Whilst it is large, I would have thought this would have zipped down by quite a bit.
See what it compresses down to and report its size. Ultimately it is up to you on the size you are prepared to upload, internet connection speed or any data limits by your ISP, etc.
Also in the request from ‘novakja’ Reply #6 you run and also upload the standard support package.
I am looking for a PERMANENT way to handle the problem that this DB File grows to such a big size.
I already know, that I can delete this File or reinstall Avast, but this fixes not the problem, that this file is growing again to such a huge size.
Cause I already discovered that the major reason for this size is, that avast permanent scanns all UPNP Connections between my PC and my Router, we need a way to tell Avast to NOT Scan UPNP Communication, or yust scan it, but not store it in this Database.