> Everything seems to be running good, but I read that to convert > this to a prebuilt database I need to squidGuard -C listfile. > Why do I need to do this?
Here's the way I understand things: One of the main reasons that squidGuard retains its speed (even with very large numbers of domains and urls), is that it stores all of the domains and urls in B-trees. (See <http://whatis.techtarget.com/definition/0,289893,sid9_gci508442,00.html>) At startup, squidGuard will look in the directory for domains.db and urls.db. If it does not find them, it will look for the text files domains and urls. If it finds those, squidGuard will create a run-time B-tree structure from the text files (the time required to create the B-tree is determined by the number of entries in the text files) and go into operation. When squidGuard is stopped, that B-tree structure is lost and will be recreated during the next startup from the text files. Running <squidGuard -C> tells squidGuard to create the B-tree structures using the text files, and then store those B-trees as domains.db and urls.db. The next time squidGuard is started there is no time wasted on created the B-trees; the db files are immediately loaded and squidGuard is ready to roll. Changes to the domains.db and urls.db files are accomplished by creating domains.diff and urls.diff files. The diff files contain: +domain to be added +domain to be added +domain to be added -domain to be removed -domain to be removed -domain to be removed Then run <squidGuard -u> to update the db files. > If so do I have to do this to every file. I use: squidGuard -C domains squidGuard -C urls I think 'all' make work also. Hope this helps. Rick > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]On Behalf Of Scott Mayo > Sent: Tuesday, July 30, 2002 9:18 AM > To: squidguard > Subject: Database > > > I have my blacklists as follows: > > /blacklists/porn files are domains urls expressions > /blacklists/warez files are domains urls > /blacklists/violence files are domains urls > > Everything seems to be running good, but I read that to convert this to a > prebuilt database I need to squidGuard -C listfile. Why do I need to do > this? Does it run faster? If so do I have to do this to every file. > IE. > squidGuard -C /blacklists/porn/domains > squidGuard -C /blacklists/porn/urls > squidGuard -C /blacklists/porn/expressions > squidGuard -C /blacklists/warez/domains > squidGuard -C /blacklists/warez/urls > squidGuard -C /blacklists/violence/domains > squidGuard -C /blacklists/violence/urls > > Scott Mayo > Tech Coordinator > Bloomfield Schools > PH: (573) 568-4564 > FX: (573) 568-5681 > Pager: (800) 264-2535 X2549 > >
