tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ronald Klop <ronald-mailingl...@base.nl>
Subject Re: RV: Session & Context variables architecture problem
Date Fri, 29 Oct 2010 11:58:11 GMT
Just query the database. Enable query caching in mysql. And only optimize in java if you see
a bottleneck.
My mysql does 15000 queries/sec.

What is your expectation of number of queries?

Ronald.


Op donderdag, 28 oktober 2010 19:31 schreef falvarez@geocom.com.uy:
> 
>  
> 
> Dear All,
> 
>                 I'm currently using Tomcat 6.0.28 and having some doubt on
> how to solve and implement this problem:
> 
>  
> 
>                                My webapp has a MySQL Database with a table
> named "parameters", in which we have just two columns ("property" and
> "value"). This table is acceded many times but doesn't change often.
> 
>  
> 
>                                For performance purposes I want to save this
> parameters in the user's tomcat session, so they are read from memory and
> not database. So far so good.
> 
>  
> 
>                                Now the problem: how can I tell this sessions
> that an attribute has changed?
> 
>  
> 
>                 I had suggestions of using "context variables" instead of
> "session variables", but that didn't solve the problem.
> 
>  
> 
> Any help in this matter is more than welcome. I have no problem in changing
> the approach, and may be not use sessions at all.
> 
>  
> 
> Thanks in advance.
> 
>  
> 
> Best regards,
> 
>                 Federico Alvarez.
> 
>  
> 
> Info:
> 
>                 Tomcat 6.0.28
> 
>                 Java 1.6
> 
>                 MySQL 5.5
> 
>                 NOT USING HIBERNATE, so 2nd Level cache is not an option
> 
> 
> 
> 
> 


Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message