Re: [Openinteract-dev] Lazy session writing ?

[Perrin H. <pe...@el...>]

And...@Be... wrote:
> monitoring our oi dbs I found, that loading and saving sessions does take
> quite some time ( we stuff quite a bit of data in there .. ).

You should probably try to move most of that out of the session. 
Putting a lot of data in a serialized session structure tends to be 
slower and less reliable than using normalized tables because you have 
to read/write the whole thing every time.

One thing that can help is a write-through cache.  You set things up so 
that it reads from a local cache instead of the db, and every time you 
write you go to the cache and the db.  You have to be sure that people 
will always return to the same server though, for this to work.

 > So, thechnically you could improve response
> time a bit, if you delay this step until after the page is already returned
> to the client.

Potentially dangerous if the save failed for some reason and the user 
didn't find out until later, but probably not a big deal.  I'd say go 
for it.

- Perrin