[squid-users] External acl efficiency: text file/MySql lookup

Hi again all,

I'm looking at writing an external acl helper that checks the value returned
by a customised version of identd. The helper would take the identd
response and compare it with data held either in flat text files or in a
MySql database. I believe I'm right in thinking that the data in the text
file or DB can be dynamic ie I can alter the data in the file or DB without
having to reconfigure Squid?

My basic question is: for a text file or DB with around 1500 lines/rows,
would there be any major performance difference between the use of text
files compared to holding the same data in a MySql database? The server
this would run on would be dedicated to running Squid and would be specced
something like:

Athlon XP 1800+ or above
512 or 1024MB DDR RAM
80GB ATA-100 7200rpm HD
Running on fully switched 100Mbit network, serving around 150 client
stations

Thanks for any response,

nry

_________________________________________________________________
On the move? Get Hotmail on your mobile phone http://www.msn.co.uk/msnmobile
Received on Sat Aug 02 2003 - 03:04:30 MDT