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 <sweettooth1...@gmail.com>:
> 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 nhibernate-development+unsubscr...@googlegroups.com.
> 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 nhibernate-development+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
