Re: Uncommited objects and Select performance

2009-05-18 Thread Rick Curtis
ommited items. > > I played with IgnoreChanges settings, but it does not seems to help. > So my question is: can I speed up those selection queries? > > Thanks, > Jan > > -- View this message in context: http://n2.nabble.com/Uncommited-objects-and-Select-performance-tp2916

Re: Uncommited objects and Select performance

2009-05-17 Thread Georgi Naplatanov
Hello, Jan may be EntityManager.flush() method will improve performance lets say on 100 inserts. Best regards Georgi Jan Kotek wrote: > Hi, > I have performance problem with queries on uncommited data. > > I run huge import, with commit at each 1 items. During import I > make lot of selectio

Uncommited objects and Select performance

2009-05-17 Thread Jan Kotek
Hi, I have performance problem with queries on uncommited data. I run huge import, with commit at each 1 items. During import I make lot of selection queries (to protect data integrity), but they are very slow. With commit every 100 items, queries run lot of faster. Profiler told me that most