Re: Sessio variables and Load Balancing

At 02:40 PM 06/30/2000 -0700, you wrote:

The session read handler should be called once at the start of the page and the write handler once at the end. With a decent session handler, it's 2 queries per page (SELECT,UPDATE), with an additional INSERT when the session is first created and a DELETE when session_destroy() is called.

Right, that is more efficient instead of re-inserting the data at every register or unregister call. But, if you work the numbers for a site that gets 25K worth of pageviews per day you are making an average of 1 query every 2 seconds just for session information. And that's average.. not what it would be during peak times and not including existing queries for content related stuff. That sounds sort of high just for serving pages. Maybe I'm wrong. Daniel