Basically this is a tradeoff and each session variable you'll add should "buy"a well identified advantage for the size you consume (ie it's best for small and very frequently used data, 22 Mb is really huge). To suggest another approach we would need to
understand how this data is used. Keep also in mind that session is scoped to each user session (ie if you have 100 users you would need to have 100 x 22 Mb ?). Is this an attempt to speed up db access or to keep changes somewhere before comitting them or
whatever ?
All-Star
48340 Points
18016 Posts
Re: capacity of a session variable
Apr 30, 2014 04:49 PM|PatriceSc|LINK
Hi,
Basically this is a tradeoff and each session variable you'll add should "buy"a well identified advantage for the size you consume (ie it's best for small and very frequently used data, 22 Mb is really huge). To suggest another approach we would need to understand how this data is used. Keep also in mind that session is scoped to each user session (ie if you have 100 users you would need to have 100 x 22 Mb ?). Is this an attempt to speed up db access or to keep changes somewhere before comitting them or whatever ?