Nothing like wasting your time to get job satisfaction...

p

On 29 Oct 2010, at 17:39, "falva...@geocom.com.uy"
<falva...@geocom.com.uy> wrote:

> Thanks Ronald and Pid for the help.
>
> Honestly I don't know if this parameters thing is really a performance issue, 
> but I've been assigned to work on it so I don't have much choice, ;).
>
> I liked the idea of a class handling the attributes in ServletContext.
>
> I'll give it a try and let you know of the outcome.
>
> Thanks again.
>
> Best regards,
>    Federico Alvarez.
>
>
>
>
> Lic. Federico Alvarez
> Analista Genexus
> ········································································
> GEOCOM Uruguay S.A.
> Dionisio Oribe 3071 // Montevideo CP 11600 // Uruguay
> Tels.: (+598) 2 481 7777 ext. 775 / Fax.: 481 7777 ext. 718
>  EnGEOCOM  nos comprometemos con el Medio Ambiente: Antes de imprimir este 
> e-mail piense bien si es necesario.
> NOTA DE CONFIDENCIALIDAD: La informacion transmitida en este mensaje y sus 
> archivos adjuntos son para la persona o entidad a la cual esta dirigida y 
> puede contener material privilegiado y/o confidencial. Su transmision se 
> encuentra legalmente protegida. Si usted ha recibido este e-mail por error, 
> comuniquelo inmediatamente por esta via su autor y eliminelo de su sistema. 
> Si usted no es el destinatario especificado en el mensaje, cualquier 
> revelacion copia o distribucion de su contenido esta estrictamente prohibida. 
> Es responsabilidad del receptor asegurarse que el mensaje y sus archivos 
> adjuntos se encuentren libres de virus. El mensaje expresa la opinion de su 
> autor pero no necesariamente la de GEOCOM Uruguay S.A. Ni GEOCOM Uruguay S.A 
> ni su autor se hacen responsables por las alteraciones que pueda sufrir este 
> mensaje a partir de su envio.
>
> -----Mensaje original-----
> De: Pid [mailto:p...@pidster.com]
> Enviado el: jueves, 28 de octubre de 2010 19:36
> Para: Tomcat Users List
> Asunto: Re: RV: Session & Context variables architecture problem
>
> On 28/10/2010 18:31, falva...@geocom.com.uy wrote:
>> 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.
>
> Do you actually know that this is a performance problem, or are you guessing 
> that it is?
>
>>                               Now the problem: how can I tell this
>> sessions that an attribute has changed?
>
> Using the session will mean that you have duplicate copies of this 
> information in each session.
>
>>                I had suggestions of using "context variables" instead
>> of "session variables", but that didn't solve the problem.
>
> *If* you need to do this, using the Context is probably better.
>
> I would suggest that you created a class which periodically updated all the 
> values by selecting the data in the DB and storing the result in the Context.
>
> Implementing a ServletContextListener will give you access to the 
> ServletContext and two methods, for app startup & shutdown, which you can use 
> to start the periodic process, and properly stop it (very important).
>
> You may consider using a Timer, or something from the java.util.concurrent 
> package.
>
>
> p
>
>> 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
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
> For additional commands, e-mail: users-h...@tomcat.apache.org
>

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
For additional commands, e-mail: users-h...@tomcat.apache.org

Reply via email to