RES: [squid-users] flat file parsing vs db filter rules parsing

Hi Muthukumar,

I have faced a problem similar to this one, some time ago. I decided to
develop another solution to manage ACL, on a profile basis, using
mysqlembedded to store ACLs, and PHP web-based scripts to manage them.

I created an helper following external_acl specification (see at:
http://devel.squid-cache.org/external_acl/ )

The projeto is hosted on Sourceforge (http://lula.sf.net) (need much updates
there - i´m without time to upload them) and everybody are welcome to see
it, send comments, help me to make it better to use, install, et cetera.

You can ask for further details on the solution and strategy, I will be glad
to share with you.

-----Mensagem original-----
De: Muthukumar [mailto:kmuthu_gct@hotmail.com]
Enviada em: segunda-feira, 25 de outubro de 2004 06:00
Para: Henrik Nordstrom
Cc: squid-users; squid-dev
Assunto: Re: [squid-users] flat file parsing vs db filter rules parsing

Hello Hendrik,

    Thanks for detailed explanation. I need some more queries as inlined as,

>> We can parse and make filter rules with flat file manner ( squid
configuration file parsing ) and database oriented parsing
>> and make filter rules ( squidguard ). Is it correct? what is the
difference between these? Is there any performance, time rate
>> and
>> difference factors between them?
>
> It depends very much on what kind of acls you are using. This is true for
both Squid and SquidGuard.

Can you prefer, which ACL types are being used as flat file parsing based
and DB filter rules parsing based. How are the parsing of
filter rules are differed in implementation. All configurations are parsed
from squid.conf flat file there. where are we using logic
of db based parsing on squid.?

> What can be said about performance is that regex lists is bad and that
redirectors (such as SquidGuard) is seriously penalized by
> the redirector interface of Squid making them unfeasible in larger setups,
at least until Squid-3.0 is released and the
> redirectors have been adapted to the new interface available there.

I heard Performance and parsing time using db based are fast. Can we adopt
db based filter rules parsing on squid-2.5 series without
using any redirectors there. How the squid-3.0 adaptation will be differed
from now?

Can you prefer, how we can know filter rules parsing with flat files or db
based conceptually? We are on-going with source files of
squid's *cf* .c and .h files. We are on the analysis to improve squid filter
rules parsing and filter adapation.

Thanks for your information and time.

Regards
Muthukumar.

---
===============  It is a "Virus Free Mail" ===============
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.779 / Virus Database: 526 - Release Date: 10/19/2004