1. ScrollableResults iteration performance forum.hibernate.orgHi All, I have a ScrollableResult iterator that I'm using to recurse through a result set of about 10,000 - 100,000 rows and was looking at the performance. I obviously clear the Session cache every nth object, yet performance of the iteration doesn't seem to be as fast as I would like it to be. I see it takes about 30 ... |
2. Long iteration performance problem forum.hibernate.orgNewbie Joined: Mon Aug 16, 2010 12:32 pm Posts: 12 Hi, I am trying to iterate over a big table about 2.5Gb and 4Mil records, I am using multithreading too The problem is that the application starts out very good at about 40Mb/sec and than slowly deteriorates to below 1Mb/sec in a almost linear fashion I have tried almost everything and ... |
3. Decreasing performance with iteration forum.hibernate.orgHi, When I iterate over my join table I get decreasing performance till the whole thing just stopps I have 1 main table with 4.5 million records 2nd join table with 30 Million records 3rd 'category' table with 12 thousand records So the mapping table joins the main table with the 'category' table With 5 threads the whol thing starts at ... |