Re: [libreoffice-marketing] Re: Nightly Rush Calc Threading video was: It's Sunday night - lets fiddle with Calc Threading...
Good work and improved a lot. > What I would like to do to end it is to thank the folks who actually did > the engineering work behind the work. > How would that best be? > It would be great. It would be great to inform the variation in the performance depending on the spreadsheet content. Sincerely, Sreekanth V K Sent with ProtonMail Secure Email. ‐‐‐ Original Message ‐‐‐ On Monday, January 21, 2019 6:05 AM, Drew Jensen wrote: > OK - it's Sunday night and after a week this is where this is at. > > Added a few lines to the script. > > > > LibreOffice 6.2 becomes the second release to offer multi-core threading as > standard feature. > > With threading support spreadsheet calculation performance is significantly > enhanced. > > In this video we will use an example file from the Architectural profession. > > Our example spreadsheet contains 234,000 data points used to compute ETTV > (Envelope Thermal Transfer Value) for an entire building. > > We are using a representative office computer with AMD 4 core processor and > 8GB of ram and Ubuntu 18.04 operating system. > > A full recalc of the Building Design spreadsheet using LibreOffice 6.0.7 > takes 50.14 sec, > > the same file using LibreOffice 6.2.0, with multi-core threading, only > 12.06 seconds. > > A 75.95% performance increase! > > How much of a performance increase will you see in your Calc worksheets? > > This depends largely on how calculation heavy your work is. > > Representative benchmark spreadsheets covering scenarios from Stock Pricing > to Water Table Monitoring > > produced performance increases ranging from 37% to 75% with this 4 core > processor based system. > > > > Kept the graphics layout and put another quick read of a voice over. Used a > tool to strip out excess blank space in the audio and got a bit over > zealous with it, but good enough for a draft. > Which is here: https://youtu.be/WBGLyogqKYI > > What I would like to do to end it is to thank the folks who actually did > the engineering work behind the work. > How would that best be? > > Thanks > > Drew > > On Sun, Jan 20, 2019 at 9:38 AM Drew Jensen drewjensen.in...@gmail.com > wrote: > > > Otherwise not sure if the noise is because it's not that bad or not that > > good.. > > Anyway - a little self critiquing on the graphics and layout and here one > > more pass over the material. > > So if you look at what I have now it begs the question - what to put on > > the end of it? > > First, I thought it would be good to mention that not every spread sheet > > is going to see a 76% performance increase in re-calcs. > > I figure the easiest way is to reference the other 4 files and the numbers > > from them. > > Yes? > > So - here is the latest draft https://youtu.be/_aClBaBCdYE > > On Wed, Jan 16, 2019 at 8:37 PM Drew Jensen drewjensen.in...@gmail.com > > wrote: > > > > > So I wrote a first draft of a script; short and simple > > > > > > --- > > > > > > LibreOffice 6.2 will be the second release to offer multi-core threading > > > as a standard feature. > > > With threading support spreadsheet calculation performance is > > > significantly enhanced. > > > In this video we will use an example file from the Architectural > > > profession. > > > Our example spreadsheet contains 234,000 data points used to compute ETTV > > > (Envelope Thermal Transfer Value) for an entire building. > > > We are using a representative office computer with AMD 4 core processor > > > and 8GB of ram and Ubuntu 18.04 operating system. > > > A full recalc of the Building Design spreadsheet using LibreOffice 6.0.7 > > > takes 50.14 sec, > > > the same file using LibreOffice 6.2.0, with multi-core threading, only > > > 12.06 seconds. > > > > > > A 75.95% performance increase! > > > > > >
[libreoffice-marketing] Re: Nightly Rush Calc Threading video was: It's Sunday night - lets fiddle with Calc Threading...
OK - it's Sunday night and after a week this is where this is at. Added a few lines to the script. LibreOffice 6.2 becomes the second release to offer multi-core threading as standard feature. With threading support spreadsheet calculation performance is significantly enhanced. In this video we will use an example file from the Architectural profession. Our example spreadsheet contains 234,000 data points used to compute ETTV (Envelope Thermal Transfer Value) for an entire building. We are using a representative office computer with AMD 4 core processor and 8GB of ram and Ubuntu 18.04 operating system. A full recalc of the Building Design spreadsheet using LibreOffice 6.0.7 takes 50.14 sec, the same file using LibreOffice 6.2.0, with multi-core threading, only 12.06 seconds. A 75.95% performance increase! How much of a performance increase will you see in your Calc worksheets? This depends largely on how calculation heavy your work is. Representative benchmark spreadsheets covering scenarios from Stock Pricing to Water Table Monitoring produced performance increases ranging from 37% to 75% with this 4 core processor based system. --- Kept the graphics layout and put another quick read of a voice over. Used a tool to strip out excess blank space in the audio and got a bit over zealous with it, but good enough for a draft. Which is here: https://youtu.be/WBGLyogqKYI What I would like to do to end it is to thank the folks who actually did the engineering work behind the work. How would that best be? Thanks Drew On Sun, Jan 20, 2019 at 9:38 AM Drew Jensen wrote: > Otherwise not sure if the noise is because it's not that bad or not that > good.. > > Anyway - a little self critiquing on the graphics and layout and here one > more pass over the material. > > So if you look at what I have now it begs the question - what to put on > the end of it? > > First, I thought it would be good to mention that not every spread sheet > is going to see a 76% performance increase in re-calcs. > > I figure the easiest way is to reference the other 4 files and the numbers > from them. > > Yes? > > So - here is the latest draft https://youtu.be/_aClBaBCdYE > > On Wed, Jan 16, 2019 at 8:37 PM Drew Jensen > wrote: > >> So I wrote a first draft of a script; short and simple >> >> LibreOffice 6.2 will be the second release to offer multi-core threading >> as a standard feature. >> >> With threading support spreadsheet calculation performance is >> significantly enhanced. >> >> In this video we will use an example file from the Architectural >> profession. >> >> Our example spreadsheet contains 234,000 data points used to compute ETTV >> (Envelope Thermal Transfer Value) for an entire building. >> >> We are using a representative office computer with AMD 4 core processor >> and 8GB of ram and Ubuntu 18.04 operating system. >> >> A full recalc of the Building Design spreadsheet using LibreOffice 6.0.7 >> takes 50.14 sec, >> the same file using LibreOffice 6.2.0, with multi-core threading, only >> 12.06 seconds. >> >> A 75.95% performance increase! >> --- >> >> Used my poor quality microphone capture of reading the script and got it >> down to 42 seconds. >> >> Put a a nightly rush video to that https://youtu.be/suRcgtBos9A >> >> >> >> On Wed, Jan 16, 2019 at 1:22 PM Drew Jensen >> wrote: >> >>> Before I forget - the files used for to gather these runtime numbers, >>> posted in an earlier email, are found here: >>> https://gerrit.libreoffice.org/#/admin/projects/benchmark >>> >>> There are five xls files with an explanation as to what the spreadsheet >>> is evaluating. >>> >>> They are 4 years old and seem to be as good as I've found for example >>> files to show the multi-core threading feature. >>> >>> Seems to me it might be worthwhile to offer them for download (maybe as >>> a zip file) and reference that download location in the video and/or >>> associated posting text. >>> >>> Also, yesterday I went back and reviewed a number of the blog posts and >>> a few media posts regarding threading (OpenCL and Multi-Core), thought that >>> was a good first step in writing up a script for use here. >>> >>> Have also gone through the Calc Functions list, as supplied in the Calc >>> Guide (updating it from 4.1 - 6.2) and have marked which functions are >>> thread enabled and which are not - not sure I have an exhaustive list but >>> should be close if not there. That is not really a marketing issue but in a >>> marketing piece listing the categories of statistical functions supporting >>> the feature seems to make sense. >>> >>> OK - that's it for this email. >>> >>> On Tue, Jan 15, 2019 at 2:32 PM Drew Jensen >>> wrote: >>> Howdy, On Mon, Jan 14, 2019 at 2:17 AM Sreekanth V K < sreekanth.vettikk...@protonmail.com> wrote: > The last one looks good for me. However, the operation which is > happening is not visible, so for
[libreoffice-marketing] Re: Nightly Rush Calc Threading video was: It's Sunday night - lets fiddle with Calc Threading...
Otherwise not sure if the noise is because it's not that bad or not that good.. Anyway - a little self critiquing on the graphics and layout and here one more pass over the material. So if you look at what I have now it begs the question - what to put on the end of it? First, I thought it would be good to mention that not every spread sheet is going to see a 76% performance increase in re-calcs. I figure the easiest way is to reference the other 4 files and the numbers from them. Yes? So - here is the latest draft https://youtu.be/_aClBaBCdYE On Wed, Jan 16, 2019 at 8:37 PM Drew Jensen wrote: > So I wrote a first draft of a script; short and simple > > LibreOffice 6.2 will be the second release to offer multi-core threading > as a standard feature. > > With threading support spreadsheet calculation performance is > significantly enhanced. > > In this video we will use an example file from the Architectural > profession. > > Our example spreadsheet contains 234,000 data points used to compute ETTV > (Envelope Thermal Transfer Value) for an entire building. > > We are using a representative office computer with AMD 4 core processor > and 8GB of ram and Ubuntu 18.04 operating system. > > A full recalc of the Building Design spreadsheet using LibreOffice 6.0.7 > takes 50.14 sec, > the same file using LibreOffice 6.2.0, with multi-core threading, only > 12.06 seconds. > > A 75.95% performance increase! > --- > > Used my poor quality microphone capture of reading the script and got it > down to 42 seconds. > > Put a a nightly rush video to that https://youtu.be/suRcgtBos9A > > > > On Wed, Jan 16, 2019 at 1:22 PM Drew Jensen > wrote: > >> Before I forget - the files used for to gather these runtime numbers, >> posted in an earlier email, are found here: >> https://gerrit.libreoffice.org/#/admin/projects/benchmark >> >> There are five xls files with an explanation as to what the spreadsheet >> is evaluating. >> >> They are 4 years old and seem to be as good as I've found for example >> files to show the multi-core threading feature. >> >> Seems to me it might be worthwhile to offer them for download (maybe as a >> zip file) and reference that download location in the video and/or >> associated posting text. >> >> Also, yesterday I went back and reviewed a number of the blog posts and a >> few media posts regarding threading (OpenCL and Multi-Core), thought that >> was a good first step in writing up a script for use here. >> >> Have also gone through the Calc Functions list, as supplied in the Calc >> Guide (updating it from 4.1 - 6.2) and have marked which functions are >> thread enabled and which are not - not sure I have an exhaustive list but >> should be close if not there. That is not really a marketing issue but in a >> marketing piece listing the categories of statistical functions supporting >> the feature seems to make sense. >> >> OK - that's it for this email. >> >> On Tue, Jan 15, 2019 at 2:32 PM Drew Jensen >> wrote: >> >>> Howdy, >>> >>> On Mon, Jan 14, 2019 at 2:17 AM Sreekanth V K < >>> sreekanth.vettikk...@protonmail.com> wrote: >>> The last one looks good for me. However, the operation which is happening is not visible, so for a common person, he/she may not be able to understand the difference. It would be better if you have the Calc in the background (not just writing what is going on) and keep the system monitor over the Calc. >>> >>> Thanks for the feedback - the current drafts certainly lack context. The >>> spreadsheet itself doesn't give much if any visual clues as to what is >>> happening. It was my goal to use the System Monitor screen capture to show >>> what is actually happening here. In the one case (LibreOffice versions >>> without threading) you can see that a single processing is spiking to 100% >>> for most of the work time, and compare that to LibreOffice 6.2 spreading >>> the load across all for processors with each running at ~60% maximum while >>> finishing the actual task significantly faster. >>> >>> That said I agree with you that there needs to be more to explain what >>> they are seeing. >>> >>> Best wishes, >>> >>> Drew >>> Sincerely, Sreekanth V K Sent with ProtonMail Secure Email. ‐‐‐ Original Message ‐‐‐ On Monday, January 14, 2019 12:10 PM, Drew Jensen < drewjensen.in...@gmail.com> wrote: > and I kept at it for a little while, > > So a real first draft, I put the two runs one after so the run length went > to 1:13 > https://youtu.be/_jtmydRYSoU > > The sound track is not quite right, some popping with the car engine mix, > but you get the idea. > > What do you think? > > and now it is no longer Sunday here, > > Drew > > On Sun, Jan 13, 2019 at 11:37 PM Drew Jensen drewjensen.in...@gmail.com > wrote: > > > Sorry, lets try that URL again for the
