Re: [cgiapp] "Best free DB for a web-based Perl app" responseresults...

From: John Armstrong
>There was cross-agreement that Postgres is slower than MySql,

Maybe this is irrelevant, but... don't forget to consider which data is primarily read-only and might be faster served from a caching system (optimized for reads instead of writes/transactions) like SleepyCat or the much simpler Perl module Cache::Cache (search CPAN, or Perl-cache on Sourceforge. I've used 1.04. There's a newer version but the author said it's a fork and doesn't recommend it.). You can do things to refresh the cache hourly or daily (as a batch job) and alleviate some load on your database.

I only mentioned it because you mentioned performance a couple times.

Mark