[Hibernate] Re: slow performance on flush

[Gavin K. <ga...@ap...>]

Just use a new Session for each loop iteration. It is even possible in a =
special case like this to have multiple sessions in the same JDBC =
transaction.=20

for ( int i=3D0; i<100; i++) {
    Session s =3D sf.openSession(conn);
    for ( int j=3D0; j<100; j++) {
        s.save( ... );
    }
    s.flush();
    s.close();
}
conn.commit();

However I suspect in this case you are better off doing it in multiple =
transactions....

  ----- Original Message -----=20
  From: Christoph Sturm=20
  To: Gavin King=20
  Cc: hibernate list=20
  Sent: Tuesday, November 26, 2002 12:27 AM
  Subject: Re: slow performance on flush


  I have a really long running import, and I want to write the records =
to the db as they come in. Is it save to clear the entries Map after a =
flush? Or would you recommend a different approach?


    ----- Original Message -----=20
    From: Gavin King=20
    To: Christoph Sturm=20
    Cc: hibernate list=20
    Sent: Monday, November 25, 2002 2:23 PM
    Subject: Re: slow performance on flush


    Yup, all entries are kept in the session cache until you close the =
session. Why would you use this kind of code?? Just flush() once at the =
end (outside the loop).
      ----- Original Message -----=20
      From: Christoph Sturm=20
      To: hib...@li... ; Gavin King=20
      Sent: Tuesday, November 26, 2002 12:18 AM
      Subject: slow performance on flush


      Hi all!

      I'm trying to increase the performance of this pseudocode:

      for (j=3D1;j<100;j++)
      {
          for (i=3D1;i<100;i++)
          {
              session.save(class)
          }
          session.flush();
          session.connection().commit();
      }


      Now my problem is that flush doesnt take a constant time, but =
every invocation of flush takes more time than the last one, the more I =
flush the slower it gets. To me it looks like hibernate keeps the =
references to the flushed objects in the entries map, and doesnt remove =
them. Is there anything I can do about it?

      regards
       chris