On 23/04/2020 22:15, Mike Kaganski wrote: > 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. Try dragging a formula down 6000 rows, you have time for a cup of tea and a snack. I doubt anyone wanting to use the advantage of multithreading will be dragging formulae many cells. So it would be an advantage to know how to optimise for multithreading. Steve
-- To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/documentation/ Privacy Policy: https://www.documentfoundation.org/privacy