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

Hello Henrik,

    Thanks for youe detailed explanations.

>> We are trying to attain good performace compared to DB filters, so that which database will be appropriate to again this.
>> Selection list is as, MySQL, .. BDB...
>
> As I said, most peole needing performance in this kind of applications selects Berkeley DB.

We are having two way of processing to get filter rules from DB as,

    1. strtokFile() <-- reads filter rules from DB file. (acl test urlpath_regex -i "/etc/database.db")
            Processed filter rules are stored in system memory with splay tree's data sturcture / linked structures.
            Reads stored filter rules from system memory and process client requests.

            It requires, Automatic updation on DB needed. Reconfiguration of squid will keep new changes.

    2. strtokFile() <--- reads filter rules from FLAT file (/etc/urlsites) ( acl test urlpath_regex -i "/etc/urlsites" )
            Processed filter rules are then moved into a database as CONTIGUOUS manner ( Marshelling on BDB ).
            Reads stored filter rules from DB, store into the system memory (UnMarshelling on BDB)
            Then process every client requests.

            It requires, Automative updation of FLAT files so that DB changes will be modified based on it.
            Reconfiguration of squid will keep new changes.

In this, which design will give performance differance.

Regards
Muthukumar.

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