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 no-op? Jochem ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
