Re: getting Squid logfiles into a database

On Tue, 12 Jan 1999 18:23:51 +1100 (EST), Gavin Cameron wrote:

[snip]
>It would be helpful, I think it would be, to be able to get your access
>logs put into a database, and I think it could be done in much the same
>way as authentication

Is there a need to have the transactions available in the database
immediately? If not you'd probably be better off syphoning them into
a database at the end of each day using your database's variant of
psql's "copy" command. This gets around the need to do a single
INSERT operation for every cache transaction - something that could,
on a busy cache, lead to the db insertions taking longer than the
logging period.

Ian

-- 
Senior Research Engineer
Mirror Image Internet