Hello,
I've one query performance problem.
I hope you can help me. Even little help should be very very helpful for
me - any tip could be great for me.
I have no idea what I can do more.
So - I try to describe the problem and will be preaciated for answer and
any tip, if you will know what could be "wrong".
The problem I have is about migration web app from NH 2.1.1.4 to NH
3.3.1.4 (ASP.MVC 2 to ASP.MVC 4).
It takes two days but is working okay now.
The problem is with queries performance.
In the ASP.MVC2 and NH 2.1.1.4 queries was really fast. NHProfiler show 0
or 1 ms time for every second round trip, without second level cache (looks
like mysql db query caching).
In the ASP.MVC4 and NH 3.x queries are always slower, because NH gets
data every time without any caching. So queries takes always some normal
(long) time (in ms) (like without any caching).
I think the point is that previous version of NH was using some kind of
not documented caching - some "feature" which was good for me and not
controlled consciously or NH3 is not using or making db to not caching
anything - really don't know.
Now queries are slower because NH3 is getting normally data without any
caching.
Two applications: in MVC2 and MVC3 (NH2 and NH3) has the same logic, the
same nh config files, the same connection string and the same DB.
The difference is in the NH (FluentNH etc) and MVC versions.
I'm just thinking - what was in the NH2, which is not exists in the NH3,
that queries was getting faster.
I'm using MySQL.Also MySQL .net connector was updated, but tried to use
old one in MVC4/NH3 app and the same behaviour.
Maybe MySQL DB is not using default query cache? But why? MVC2/NH2 app
has no problem with it. MVC4/NH3 has different behaviour.
Do You have any idea?
Do you know what can be wrong or what is the difference between those
versions of NH, that queries have different query time behaviour?
I checked almost everyting. NH config, configuration, sys cache etc.
Everything are the same I think - not sure.
Below is my web config (the same before in NH2 and now in NH3):
<?xml version="1.0" encoding="utf-8" ?>
<hibernate-configuration xmlns="urn:nhibernate-configuration-2.2">
<session-factory>
<property
name="connection.connection_string">Server=localhost;Database=db;Uid=root;Pwd=root;Pooling=false</property>
<property name="dialect">NHibernate.Dialect.MySQL5Dialect</property>
<property
name="connection.provider">NHibernate.Connection.DriverConnectionProvider</property>
<property
name="connection.driver_class">NHibernate.Driver.MySqlDataDriver</property>
<property name="show_sql">false</property>
<property name="connection.release_mode">auto</property>
<property name="adonet.batch_size">500</property>
<property
name="proxyfactory.factory_class">NHibernate.Bytecode.DefaultProxyFactoryFactory,
NHibernate</property>
<property name="hbm2ddl.keywords">auto-quote</property>
<property
name="cache.provider_class">NHibernate.Caches.SysCache.SysCacheProvider,
NHibernate.Caches.SysCache</property>
<property name="cache.use_query_cache">true</property>
<property name="cache.use_second_level_cache">false</property>
<!--<property name="cache.expiration">300</property>-->
<!--<property
name="cache.provider_class">NHibernate.Caches.MemCache.MemCacheProvider,NHibernate.Caches.MemCache</property>-->
</session-factory>
</hibernate-configuration>
Freud
--
You received this message because you are subscribed to the Google Groups
"nhusers" group.
To view this discussion on the web visit
https://groups.google.com/d/msg/nhusers/-/SsYwHS-Dl7gJ.
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/group/nhusers?hl=en.
