Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version: 2


hi.. we have log of "read-only" objects in our database and i've noticed using a profiler, calls though query and critira invoke flushes which take a long time, is it reasobile to turn off the flush just before the these specfic calls, and turn it back on again.

this also happens even if the objects are located in 2nd level cache, which always made me wonder why our processes are still slow.

what are queryspaces ? i heard they are related some how.

You can control automatic flush using the following:

or

or

ngagov has it right,

you can manually control the flushing by setting the flush modes at runtime. Btw, thanks ngagov, I never noticed that the Criteria API exposed that.

hi_user,
As for queryspaces, they are essentially the tables that will be read during a query. During auto flushing, hibernate will look to see what tables you will be querying against and if there are dirty objects in your session that refer to these tables then the actual flush will occur.

If your flushes are taking a very long time you may also want to consider flushing and clearing your session from time to time to keep it manageable. If you're using the Query API you can also tag the query as read only which will avoid creating the db snapshot for the object. There's been some chatter in the JIRA section to allow the same type of functionality for Criteria queries as well.