I was wrong, one of our devs set cacheble to false on the queries, so all the counts I've noticed on the mysql logs were actually from that service.
Thanks. On Tue, Sep 22, 2009 at 5:49 PM, Ayende Rahien <[email protected]> wrote: > Antonio, > It most certainly should be able to cache formulas. Do you have an example > where it doesn't? > > > On Tue, Sep 22, 2009 at 7:45 PM, Antonio Terreno < > [email protected]> wrote: > >> I've changed few criteria queries setting .SetCacheble(true) and now >> everything makes sense. >> >> Another impression is that hibernate can't cache formulas (we have few >> count done with formulas on a couple of entities), am I wrong? >> >> Thanks for your help. >> >> On Tue, Sep 22, 2009 at 4:09 PM, Ayende Rahien <[email protected]> wrote: >> >>> Antonio, >>> There is no relation to the database backend in SysCache >>> >>> SysCache2 (stupid name) have dependencies on SQL Server, but not SysCache >>> >>> >>> On Tue, Sep 22, 2009 at 4:37 PM, Antonio Terreno < >>> [email protected]> wrote: >>> >>>> Thanks, I've actually found that there was some duplication between the >>>> Web.Config and the hibernate.xml (spring) file. >>>> >>>> Another question: does SysCache work with MySql DB or it works only with >>>> MS SQL Server? >>>> >>>> On the doc I see: >>>> >>>> SysCache2 requires Microsoft SQL Server 2000 or higher and .NET >>>>> Framework version 2.0 or higher. >>>>> >>>>> >>>> >>>> We are planning to use MS SQL Server, but at the moment on the query >>>> logs of mysql I can still see the queries performed each time, even on >>>> simple select from where id=? >>>> >>>> Thanks again. >>>> toni >>>> >>>> >>>> On Tue, Sep 22, 2009 at 10:22 AM, Ayende Rahien <[email protected]>wrote: >>>> >>>>> Drop the hibernate prefix >>>>> >>>>> >>>>> On Tue, Sep 22, 2009 at 11:28 AM, Antonio Terreno < >>>>> [email protected]> wrote: >>>>> >>>>>> Hi all, >>>>>> I'm getting this message even if I'm pretty sure I've followed the >>>>>> "manual" on how to enable the 2nd level cache on our application. >>>>>> >>>>>> On our hibernate.xml I've set up the cache as it follows: >>>>>> >>>>>> <object id="SessionFactory" >>>>>>> type="Spring.Data.NHibernate.LocalSessionFactoryObject, >>>>>>> Spring.Data.NHibernate21" singleton="true"> >>>>>>> <property name="DbProvider" ref="DbProvider" /> >>>>>>> <property name="MappingAssemblies"> >>>>>>> <list> >>>>>>> <value>XXX.BusinessDomain</value> >>>>>>> </list> >>>>>>> </property> >>>>>>> <property name="HibernateProperties"> >>>>>>> <dictionary> >>>>>>> <entry key="hibernate.connection.provider" >>>>>>> value="NHibernate.Connection.DriverConnectionProvider"/> >>>>>>> <entry key="hibernate.connection.driver_class" >>>>>>> value="NHibernate.Driver.MySqlDataDriver"/> >>>>>>> <entry key="hibernate.dialect" >>>>>>> value="NHibernate.Dialect.MySQLDialect"/> >>>>>>> <entry key="hbm2ddl.keywords" value="none"/> >>>>>>> <entry key="proxyfactory.factory_class" >>>>>>> value="NHibernate.ByteCode.Castle.ProxyFactoryFactory, >>>>>>> NHibernate.ByteCode.Castle"/> >>>>>>> <entry key="hibernate.cache.provider_class" >>>>>>> value="NHibernate.Caches.SysCache.SysCacheProvider,NHibernate.Caches.SysCache" >>>>>>> /> >>>>>>> <entry key="cache.use_second_level_cache" value="true" >>>>>>> /> >>>>>>> <entry key="expiration" value="300" /> <!-- five minutes, at >>>>>>> the minute --> >>>>>>> </dictionary> >>>>>>> </property> >>>>>>> <property name="ExposeTransactionAwareSessionFactory" >>>>>>> value="true" /> >>>>>>> </object> >>>>>>> >>>>>>> >>>>>> On our web.config as it follows: >>>>>> >>>>>>> >>>>>>> </configSections> >>>>>>> ... >>>>>>> <section name="syscache" >>>>>>> type="NHibernate.Caches.SysCache.SysCacheSectionHandler, >>>>>>> NHibernate.Caches.SysCache" requirePermission="false" /> >>>>>>> </configSections> >>>>>>> >>>>>> >>>>>> >>>>>>> <syscache> >>>>>>> <cache region="entities" expiration="3600" priority="5" /> >>>>>>> <cache region="LongTerm" expiration="3600" priority="5" /> <!-- >>>>>>> as a reference --> >>>>>>> <cache region="ShortTerm" expiration="900" priority="3" /> <!-- >>>>>>> as a reference --> >>>>>>> </syscache> >>>>>>> >>>>>> >>>>>> On the entities that I want to cache: >>>>>> >>>>>> <class name="XXX"> >>>>>>> <cache usage="nonstrict-read-write" region="entities" /> >>>>>>> >>>>>>> >>>>>> If you guys think that this is good we might have a problem elsewhere >>>>>> (no idea where, perhaps templating config files..) >>>>>> >>>>>> >>>>>> Thanks for your patience and help. >>>>>> >>>>>> toni >>>>>> >>>>>> -- >>>>>> http://www.the-arm.com >>>>>> >>>>>> >>>>>> >>>>> >>>>> >>>>> >>>> >>>> >>>> -- >>>> http://www.the-arm.com >>>> >>>> >>>> >>> >>> >>> >> >> >> -- >> http://www.the-arm.com >> >> >> > > > > -- http://www.the-arm.com --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "NHibernate Contrib - Development Group" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com.ar/group/nhcdevs?hl=en -~----------~----~----~----~------~----~------~--~---
