Oh, btw, this list is of discussion development of NHibernate, Please see the nhusers lists for questions regarding using NHibernate.
/Oskar Den tors 6 dec. 2018 kl 15:08 skrev Oskar Berggren <[email protected] >: > You seem to be using database generated identifiers - this mean NHibernate > needs to send each INSERT separately during the call to Save() instead of > sending them all in a batch during flush phase. > > /Oskar > > > Den tors 6 dec. 2018 kl 06:47 skrev <[email protected]>: > >> Hello >> >> >> Let’s say we have a simple *test* table in our database and we use a >> simple Hibernate object in order to work with it. >> >> The addition of 150 entries (150 *ISession.Save()* calls) in a single >> transaction can easily take *100-200 milliseconds* (in case of *MySQL* and >> in case of *Postgresql* database)… >> >> >> Is this normal, or are we missing something and we should change >> something in Hibernate / our database in order to improve the performance >> of the rows addition operation? >> >> We have tried to disable flushing and call it before the Commit(), but it >> hasn’t changed much… >> >> >> [Class(Table = “test”)] >> public class TestEntity >> { >> private int id; >> [Id(0, Column = “id”, Name = “Id”)] >> [Generator(1, Class = “native”)] >> public virtual int Id { get { return id; } set { id = value; } } >> >> >> [Property(Column = "test_column")] >> >> protected virtual float testColumn { get; set; } >> >> public virtual float TestColumn { get { return testColumn; } set { if >> (testColumn != value) { testColumn = value; } } } >> >> >> public TestEntity() { } >> >> >> public TestEntity(float t) >> >> { >> >> this.testColumn = t; >> >> } >> >> } >> >> >> -- >> >> --- >> You received this message because you are subscribed to the Google Groups >> "nhibernate-development" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected]. >> For more options, visit https://groups.google.com/d/optout. >> > -- --- You received this message because you are subscribed to the Google Groups "nhibernate-development" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
