Perrin,
Thanks for the replies. Adding an index made a significant improvement on
performance -- it's still three or four times slower than without
Apache::Session, but much faster than without the index.
Thanks again,
Chris
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
--
Chris Brooks
Director of Technology
CareScout.com
phone: (781) 431-7033 x 342
