Welcome Guest, Not a member yet? Register   Sign In
Possible to only store some data in the Sessions table? (about 1.7.0 change)
#1

[eluser]inktri[/eluser]
I maintain some data that is non critical in the session cookie and I have to access to access it a lot. Therefore I want to keep some stuff solely in the session cookie so my script doesn't make so many DB calls. Is that possible? or should I just create another cookie for the non critical data?
#2

[eluser]meade[/eluser]
I would suggest creating a denormalized table to maintain user specific/session specific data instead of using cookies to store data. I'm no cookie expert, but I would imagine the time to read/transmit a cookie (if stored on the client) is not much different then a well formed table. There's also some size limits on cookies, time expiration, etc.
#3

[eluser]inktri[/eluser]
Can someone shed some light as to how the Sessions table works?

I've autoloaded the Session class. For every refresh, does MySQL do a SELECT WHERE id=id on the Sessions table? Or does that only happen when I call get userdata() in my PHP page?




Theme © iAndrew 2016 - Forum software by © MyBB