Re: mysql sessions vs flat file?

Jason Morehouse wrote:

Hello all, Has anyone had an experience with storing sessions in mysql (or sqlite)? If so, what if any are the performance benefits? Obviously, there would have to be an extra db query per page... but would that be faster then opening a text file?

Speed depends on several factors and I would not comment on it. One of the main advantages of placing session information in the database is that your web application can then be clustered more easily. The other advantage is that if you are on a shared hosting enviorenment there some measure of additional protection for your session data when it's stored in the database. The main disadvantage is that you are complicating your application a bit and session management errors may become harder to track.

Also, I was trying to post to the php news server, but my messages weren't showing up. Is it read only? Or just slow? Cheers, -J

-- Raditha Dissanayake. ------------------------------------------------------------------ http://www.radinks.com/print/card-designer/ | Card Designer Applet http://www.radinks.com/upload/ | Drag and Drop Upload