On Mon, 28 Aug 2000, Chris Brooks wrote:
> I went back through the documentation on Apache::Session,
> Apache::Session::DBIStore, and Apache::DBI, and I haven't found a
> problem in the way we have implemented this. Does anyone else have
> suggestions, or has anyone else experienced a similar performance hit?
You're not doing anything wrong. As I said before, going to a databse on
every request is expensive. It will definitely crush your performance
when compared to something really lightweight like serving static files
with no db access. You could try using one of the other session stores
like FileStore to see if it's any faster for you, or you could try running
MySQL on the same machine as the web server, but if you have significant
traffic you will eventually need a separate db server machine and a
cluster of web servers.
The only thing I could suggest for improving the performance of your setup
is to make sure you have MySQL properly tuned, with an appropriate index
on this table.
- Perrin
