Chris Allen wrote: > In desperation, I have switched to Cache::FileCache - which > works fine, but I would be interested to know, for a system > that handles several hundred database queries per minute: > > - What is the performance difference between SharedMemoryCache > and FileCache?
You can test it yourself with the supplied benchmark script. In general, file caching is faster for most applications. > - What is the performance difference between FileCache and a > local MySQL database (on a simple indexed query)? FileCache will probably beat MySQL, but maybe not by much. There were some benchmarks posted here a while back which might interest you. The thread starts here: http://marc.theaimsgroup.com/?l=apache-modperl&m=100812999912375&w=2 - Perrin