[Libreoffice-bugs] [Bug 129166] XCellRangeData::setDataArray is many times slower when data contains some empty strings

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=129166

--- Comment #2 from Mike Kaganski <mikekaganski at hotmail.com> ---
Saving to an ODS and reloading each test result gives these results:

1. Saving and reloading results of original code using `if (i mod 10 = 0) Then
data(i) = array("0") else data(i) = array(CStr(i))`, the reload takes ~13 s
2. Saving and reloading results of test in comment 1 using `if (i mod 10 = 0)
Then data(i) = array(" ") else data(i) = array(CStr(i))`, the reload takes ~35
s
3. Saving and reloading results of test in comment 0 using `if (i mod 10 = 0)
Then data(i) = array("") else data(i) = array(CStr(i))`, the reload takes ~80 s

So there is a good correlation between setDataArray performance and reload time
for #1 and #2, with ~5 s constant overhead in reloading; but for #3 with empty
strings, setDataArray performs about 10 times slower than reloading its
resulting data from file.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20191204/a301e28d/attachment.html>