Performance Question

ecossian · **Posted:** Fri Jun 04, 2004 10:36 am

Hello,

I have functions in a class that need to call Hibernate as part of their job. So far, what I'm doing is as follows:

Code:

public void myFunction()
        throws MyExceptionClass
{       
       Session session = null;
        try
        {
            // sessionFactory is stored as a private variable
            session = sessionFactory.openSession();

            // doing other stuff: updates, selects, etc.

         }
            session.flush();
            session.close();
        }
        catch (HibernateException e)
        {
            throw new MyExceptionClass(e.getMessage(), activeUser);
        }
}

My questions are:

1. What is the overhead of opening up the session on every function call, flushing it, and closing?
2. Does it make sense to store sessionFactory elsewhere? Should it be in the context somewhere, accessible to all connections? Any pitfalls with this?
3. If the above solution is not optimal, what would be a better way of doing this?

Thanks very much.

anthony · **Posted:** Fri Jun 04, 2004 10:42 am

my opinion:

Quote:

1. What is the overhead of opening up the session on every function call, flushing it, and closing?
2. Does it make sense to store sessionFactory elsewhere? Should it be in the context somewhere, accessible to all connections? Any pitfalls with this?
3. If the above solution is not optimal, what would be a better way of doing this?

1- if you are flushMode = auto (by default), you should consider not manullay flush it, if you have a "commit" function, to be 100% secure you can call session.flush() and then commit
2- the best for a webApp is to use threadLocal Pattern (search open session in view on site) it's the simpliest way to manage hibernate session (and maybe sessionFactory) for such apps
3- see previous point.

Creating a sessionFactory = very expensive
Obtaining a session from a sessionFactory = not expensive
Flushing a session = can be very expensive if you call it every millisecond...[/quote]