[kepler-dev] [Bug 5429] improve default provenance store performance

[bugzilla-daemon at ecoinformatics.org]

http://bugzilla.ecoinformatics.org/show_bug.cgi?id=5429

--- Comment #2 from Derik Barseghian <barseghian at nceas.ucsb.edu> 2011-06-28 15:16:07 PDT ---
After a lot more testing with the cache_file_scale and hsqldb.cache_scale
options, and for the GDD workflow processing 200days, the ideal setting seems
to be about:

hsqldb.cache_size_scale=8 (the default. 8-10 is fine, below or above this range
is worse)
hsqldb.cache_scale=18 (max, 14 is default)

Changing from running the provenance database in server mode to file mode also
provides a significant execution time performance boost - the first run of the
workflow takes a little less than 1min.

With cache_file_scale=1, my provenance store can grow larger than 1gb. I guess
this setting means 2gb. I've yet to get a store that large to see what
happens...

-- 
Configure bugmail: http://bugzilla.ecoinformatics.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the QA contact for the bug.