Fluent NHibernate MySQL batching

Question

I need to apply batch sizing to my NHibernate Sessions. I am using MySQL.

After finding out, that NHibernate doesn't natively support batch sizing for MySQL I installed this package:

http://www.nuget.org/packages/NHibernate.MySQLBatcher

which contains a batcher for MySQL.

Then I was searching for the point where I can inject the batcher and found this:

Why doesn't NHibernate support batching on MySql

According to the accepted answer I don't find something like this DataBaseIntegration() method.

Has anyone got through this before?

I think the 4 branch will now have mysql embedded, probably not going to help you now but always good to point out for future. github.com/nhibernate/nhibernate-core/blob/master/… — Rippo
– Rippo, Commented Dec 1, 2013 at 14:13

Frank · Accepted Answer · 2013-11-29 15:33:32Z

3

I have used this package and it worked for me.

Below the configuration I used:

var cfg = new NHibernate.Cfg.Configuration();
cfg.SetProperty(NHibernate.Cfg.Environment.ConnectionProvider, "NHibernate.Connection.DriverConnectionProvider");
cfg.SetProperty(NHibernate.Cfg.Environment.ConnectionDriver, "NHibernate.Driver.MySqlDataDriver");
cfg.SetProperty(NHibernate.Cfg.Environment.Dialect, "NHibernate.Dialect.MySQLDialect");
cfg.SetProperty(NHibernate.Cfg.Environment.UseSecondLevelCache, "false");
cfg.SetProperty(NHibernate.Cfg.Environment.UseQueryCache, "false");
cfg.SetProperty(NHibernate.Cfg.Environment.GenerateStatistics, "false");
cfg.SetProperty(NHibernate.Cfg.Environment.CommandTimeout, "300");
cfg.SetProperty(NHibernate.Cfg.Environment.BatchSize, "1000");
cfg.SetProperty(NHibernate.Cfg.Environment.BatchStrategy,  typeof(MySqlClientBatchingBatcherFactory).AssemblyQualifiedName);

answered Nov 29, 2013 at 15:33

Frank

2491 silver badge6 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Jan P. Over a year ago

Thank you, will check this on monday ;)

Rippo · Accepted Answer · 2013-12-01 14:33:01Z

2

If using mapping by code syntax then my set up for batching in MySql looks like this (NH 3.3+):-

var configure = new Configuration().Configure();
configure.DataBaseIntegration(x =>
    {
        x.Dialect<MySQL5Dialect>();
        x.ConnectionStringName = "db";
        x.BatchSize = 50;
        x.Batcher<MySqlClientBatchingBatcherFactory>();

    })
    .Cache(x => x.UseQueryCache = true)
    .CurrentSessionContext<WebSessionContext>();

answered Dec 1, 2013 at 14:33

Rippo

22.5k14 gold badges83 silver badges118 bronze badges

Comments

Origin · Accepted Answer · 2014-09-06 23:19:24Z

1

If using FluentNhibernate, my mapping code might help you:

Dim fConfig As FluentConfiguration
...
fConfig.ExposeConfiguration(Function(x) x.DataBaseIntegration(Sub(y)
         y.Batcher(Of MySQLBatcher.MySqlClientBatchingBatcherFactory)()
         y.BatchSize = 100
     End Sub)

answered Sep 6, 2014 at 23:19

Origin

2,03315 silver badges33 bronze badges

Collectives™ on Stack Overflow

Fluent NHibernate MySQL batching

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related