On 6/22/06, Mark Woodward  wrote:
thousand active sessions
If an active user causes a session update once a second
Generally speaking, sessions aren't updated when they change, they are
usually updated per HTTP request. The data in a session may not change,
but the session handling code doesn't know this and simply updates anyway.

So what you are saying is that you are doing hundreds of unnecessary
updates per second and as a result of those unnecessary problems  you
have a performance problem. Why not attack the root of the problem and
make the session handler smarter? And if you can't do that, put some
logic in the session table that turns an update without changes into a


---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Reply via email to