Well when scaling isn't RAM is cheap? and RAM is faster that running queries right? I'd rather store things in session then start querying more when more users connect..."I have the need, the need for speed."
I have people writing to the database and others reading from it. I need to find a balance and adjust the queries to session variables for optimum performance, static at first, make it dynamic later. Alot of the user session variables do not have to be sync'ed with the database... their data is always more correct than the database and the records and only editable from the user and no one else. Finally I do have some application variables that all users will share and this data will change only once a day. Rich --- Adam Hardy <adam. [EMAIL PROTECTED]> wrote: > As long as you've got connection pooling and a > decent piece of hardware, > you should be able to carry out all the non-trivial > database queries you > require, given an average application requirement. > > The amount of user information you hold in their > session is limited to > the amount of available memory you have, divided by > the expected > absolute maximum number of concurrent sessions you > predict. > > I am curious though due to the way you phrase you > question, are you > contemplating balancing the session memory usage > against database usage > dynamically? > > And another question, how much user info can you > have in your > application that is static enough to hold in their > session? > > Regards > Adam > > Richard Diaz wrote: > > >I'm currently doing DB Queries and holding the > users > >information in session objects... trying to keep > the > >query load on the database down to a minimum by > using > >these session objects (MVC2). > > > >My question is where do I draw the line as far as > how > >much RAM each user gets? When do I free up those > >session objects and querying the database for > >information again? > > > >Are there any guides on this? > > > >thanks in advance, > >Rich > > > > > > > >__________________________________________________ > >Do You Yahoo!? > >LAUNCH - Your Yahoo! Music Experience > >http://launch.yahoo.com > > > >-- > >To unsubscribe, e-mail: > <mailto:[EMAIL PROTECTED]> > >For additional commands, e-mail: > <mailto:[EMAIL PROTECTED]> > > > > > > > > > > > > -- > To unsubscribe, e-mail: > <mailto:[EMAIL PROTECTED]> > For additional commands, e-mail: > <mailto:[EMAIL PROTECTED]> > __________________________________________________ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>