[CAY-1468] Commit performance degradation

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.0
• Fix Version/s: 3.0.1
• Component/s: Core Library
• Assignee: Unassigned
• Reporter: Cosmin Marian
• Created: 23/Jul/10 07:54
• Updated: 23/Jul/10 11:57
• Resolved: 23/Jul/10 11:57

Description

While developing an application using Cayenne I noticed that the
performance of DataContext.commitChanges() degrades with the number of
commits done.

To be more specific, I have a model with two entities: Result and
ResultStream, with a many to one relation from Result to ResultStream.

The test I do is simple: I generate a lot of Result objects, all linked to
the same ResultStream and I call commit after each Result added to the
DataContext and measure the time it takes to perform the commit. I notice
that this time grows fairly linear. Of course, the growth is noticeably
after generating many results

Here is the source code of the test:

public class Main {

public static void main(String[] args) {
DataContext dc = DataContext.createDataContext();

final int stepSize = 500;
final int nbSteps = 50;

SelectQuery sq = new SelectQuery(ResultStream.class);

ResultStream rs = (ResultStream) dc.performQuery(sq).get(0);

StopWatch sw = new StopWatch();
sw.start();

for (int i = 1; i <= nbSteps * stepSize; ++i) {
Result t = new Result();
t.setValue;
t.setResultStream(rs);

dc.commitChanges();

if (i % stepSize == 0)

{ sw.stop(); System.out.printf("%6d, %s, %5d\n", i, DurationFormatUtils.formatDurationHMS(sw.getTime()), sw.getTime()); sw.reset(); sw.start(); }

}
}
}