Fwd: [libreoffice-documentation] Multi-threading in Calc

[Mike Kaganski]

On 23.04.2020 13:12, Luboš Luňák wrote:
> On Thursday 23 of April 2020, Stephen Fanning wrote:
>> As for the processing itself, I remain unclear about how Calc allocates
>> tasks to threads. Can we give the user any general advice on how he could
>> structure his spreadsheet to gain the maximum performance benefits from the
>> availability of multiple cores? Or maybe there are ways to organise a
>> spreadsheet that will frustrate Calc's attempts to multi-thread, which we
>> ought to advise against?
> 
>  Technically threads are generally used only for formula groups, which are a 
> sufficient number of adjacent cells in a column that use the same formula 
> (and get different results because of relative cell addressing). In UI terms, 
> write e.g. "=A1*2" to B1, grab the bottom-right corner of the cell and extend 
> down. But it's implementated this way because that's usually how large 
> spreadsheets are created. So I think it's a needless complication to be 
> specific about this.
> 

IMO it's still useful to mention that the optimization is column-based.
Because many people don't realize that row-based layout is potentially
less efficient. This would be beneficial to those who don't create
spreadsheets according to how it's "usually" done.

-- 
Best regards,
Mike Kaganski
-------------- next part --------------
A non-text attachment was scrubbed...
Name: pEpkey.asc
Type: application/pgp-keys
Size: 1769 bytes
Desc: not available
URL: <https://lists.freedesktop.org/archives/libreoffice/attachments/20200423/9d8e5549/attachment.key>