https://bz.apache.org/bugzilla/show_bug.cgi?id=57840
--- Comment #31 from Greg Woolsey <[email protected]> --- Created attachment 33941 --> https://bz.apache.org/bugzilla/attachment.cgi?id=33941&action=edit adds a unit test file and method that make heavy use of structured reference formulas, for performance testing My latest patch attachment, patch-57840-heavy-structured-ref-formula-use-test.tar.gz, has my sample file (got approval for the sanitized version) and a test method to loop through and evaluate all the formula cells. It runs successfully, but still takes a while to process the 7,274 formula cells. most have IF() calls that execute VLOOKUP() using a structured reference to a named table with over 3,700 rows in 8 columns. This exercises things enough it can be profiled using Java Mission Control or other tools to help find the remaining code hot spots. The test could be augmented with an upper bound timing test if desired, to fail if the eval run takes longer than say 5 minutes (my last run was 90 sec.). That would flag big performance regressions, like introducing a code path that misses the evaluator caches. -- You are receiving this mail because: You are the assignee for the bug. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
