Re: [squid-users] Squid + index + SQL

From: Marcello Romani <mromani_at_ottotecnica.com>
Date: Tue, 27 Dec 2011 12:23:25 +0100

Il 26/12/2011 23:11, Fabricio Viana ha scritto:
>
> I have a question:
> Is It possible to use an SQL (PostgreSQL or MySQL) to index cache_dir content?
> Each time that Squid needs a file (JPEG, text-file, etc), Itīll do a SELECT into the database and the response will be the cache subdir and filename.
> I think that Mysql and PostgreSQL are faster to do this search than Squid itself .
> Does anyone have and ideia how to implement this?
> Thanks!

That's a very specific index that squid can keep in memory and search
(and update) in a very optimized way, i.e. very fast.
Adding an rdbms to the mix would only increase latency (thus speed),
memory consumption and administration overhead for no real benefit.
IMHO, of course.

-- 
Marcello Romani
Received on Tue Dec 27 2011 - 11:23:30 MST

This archive was generated by hypermail 2.2.0 : Tue Dec 27 2011 - 12:00:02 MST