Perrin Harkins wrote:
>
> 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
I think Perrin has already touched on this and it may be too bovious,
but if you are session managing all requests you are wasting alot of
time on non-html / dynamic content such as images, style sheets.
Greg Cope
