problem in speed while using ehCache

Thanks for all the support.

One last question (I hope so.. J).

 

How can we ensure that the cache is updated/refreshed if data is changed in the database tables?

 

We have actually added this line: -  dynamic-update="true" in the HBM File.

 

Thanks!

 

Regards,

Suhas

 

 

---

From: Greg Luck [gluck@...] 
Sent: Tuesday, May 13, 2008 12:59 PM
To: Shahapurkar, Suhas P
Subject: Re: [ehcache-list] problem in speed while using ehCache

 

Hi

 

It acts as a pull-through cache effectively. With Hibernate it does not preload. So you first hit is full cost. The second and subsequent hits are cached.

 

 

On 13/05/2008, at 4:03 PM, Shahapurkar, Suhas P wrote:

Thanks for the email.

I have tested with the changes and now it is taking much lesser time (1718ms)

 

One basic question though, when does ehCache caches the data? Loading the ehCache.xml, hibernate.cfg.xml and **.hbm.xml OR after first time retriving the data?

 

Regards,

Suhas

 

---

From: Greg Luck [gluck@...] 
Sent: Tuesday, May 13, 2008 6:16 AM
To: Shahapurkar, Suhas P
Subject: Re: [ehcache-list] problem in speed while using ehCache

 

Hi

 

Why don't you try setting the timeToLive to a large number like 5000 to make sure it is not expiring while you are using it. Remove the timeToIdle. I don't think you want that.

 

Maybe also try setting lazy to false to make sure the thing is fully loaded.

 

Set the hibernate show sql to true. That way it will show you each time it does database work. If the caching is working you should see database work disappear.

 

Remember the first time you execute the query the work gets done. Then the second time it should use the query cache.

 

You should also use a query cache. To do so do criteria.setCacheable(true) and then specify the cache name you are using with criteria.setCacheRegion("myquerycache"). Create an extra ehcache config for it.

 

This should ramp things up for you.

 

On 12/05/2008, at 6:15 PM, Shahapurkar, Suhas P wrote:

Hello,

Newbie in ehcache!

We have changed the hibernate.cfg.xml like:

 

 

<property name="hibernate.cache.provider_class">org.hibernate.cache.EhCacheProvider</property>

 

    <property name="hibernate.cache.provider_configuration">/ehcache.xml</property>

    <property name="hibernate.cache.use_minimal_puts">false</property>

    <property name="hibernate.cache.use_query_cache">true</property>

    <property name="hibernate.cache.use_second_level_cache">true</property>

    <property name="hibernate.cache.use_structured_entries">true</property>

 

     <mapping resource="customers.hbm.xml"/>

 

 

HBM File is like:-

 

<?xml version="1.0"?>

<!DOCTYPE hibernate-mapping PUBLIC

    "-//Hibernate/Hibernate Mapping DTD 2.0//EN"

    "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">

<hibernate-mapping default-access="field">

    <class name="staticdata.model.Customer"

           lazy="true" dynamic-update="true"

           table="Customers">

 

        <cache usage="read-write"/>               

          

        <id name="customerID" >

            <generator class="native"/>

        </id>

        <property name="customerShortName" type="string" />

 

                        --------------------------------

                        -------------------------------

 

ehCache file is like:

 

      <cache name="staticdata.model.Customer"

        maxElementsInMemory="2500"

        eternal="false"

        overflowToDisk="false"

        timeToIdleSeconds="300"

        timeToLiveSeconds="0"/>         

</ehcache>

 

While retrieving the record as:

 

            tx = session.beginTransaction();

           

            Criteria criteria = session.createCriteria(Customerclass);

          

criteria.add(Expression.ne(key, column.get(key)));

criteria.add(Expression.eq(key, column.get(key)));