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

From: Marcello Romani <>
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