Rossz wrote: > > Rick Matthews wrote: > > >Here's something that might make you a little more comfortable about > >running text files in the interim... Whether you are using text files > >or pre-built db files, squidGuard stores all of the domains and urls > >in in-memory-only B-trees at startup. Obviously the pre-built db > >files load much faster than building new ones. But once squidGuard > >is up and accepting transactions there is no speed difference > >between a system started with text files and one started with db > >files. I'm not trying to minimize the benefit of the db files, just > >wanted you to know specifically where the performance hit appears. > > > > > > > That's why I'm not too concerned. My lists will be very short. Mostly > a whitelist for the sales terminals. I'm not going to deal with the > rest of the computers for a while.
I don't think the start-up speed difference is even noticeable until you get up over a thousand entries. > BTW, has anyone considered (and is there any advantage) a MySQL based > database? Something like this would make it very easy for me to > implement a data entry screen so my boss could easily modify the whitelist. Here's a link to a 'mysql' search on the squidGuard list archive, complete with your last post on top: http://marc.theaimsgroup.com/?l=squidguard&w=2&r=1&s=mysql&q=b You might want to read these two posts first, before you read the rest: http://marc.theaimsgroup.com/?l=squidguard&m=107153011730561&w=2 http://marc.theaimsgroup.com/?l=squidguard&m=100864606427378&w=2 Rick
