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 <drewjensen.in...@gmail.com> 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! > > > > > > ------------------------------- > > > > > > 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 drewjensen.in...@gmail.com > > > 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 drewjensen.in...@gmail.com > > > > 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 second file > > > > > > > > https://youtu.be/ED-zipIV1dE > > > > > > > > On Sun, Jan 13, 2019 at 11:34 PM Drew Jensen > > > > > > > > drewjensen.in...@gmail.com > > > > > > > > > > > > > > > wrote: > > > > > > > > > > > > > > > > > Of course there had another one in there, heck it isn't just a > > > > > > > > > Sunday it > > > > > > > > > > > > > > > > is a snowy Sunday where I'm at. > > > > > > > > > so four versions of LO on the screen, from top left and > > > > > > > > > running > > > > > > > > > clockwise > > > > > > > > > > > > > > > > 6.0, 6.1, 6.3 alpha, 6.2 RC2 > > > > > > > > > this time the version number is overlaid the cpu monitor > > > > > > > > > screen > > > > > > > > > captures > > > > > > > > > > > > > > > > and fade out, in timing similar to the calculation time... > > > > > > > > > https://youtu.be/FMSPMWGdNO0 > > > > > > > > > Anyway - realizing calculation threading became standard last > > > > > > > > > release I > > > > > > > > > > > > > > > > was thinking it worth a mention in a social media post for the > > > > > > > > > coming 6.2 > > > > > > > > > > > > > > > > as the developers have continued working on the feature. > > > > > > > > > So, these are some first ideas for a video to go along with > > > > > > > > > that > > > > > > > > > TBD post > > > > > > > > > > > > > > > > text. > > > > > > > > > Suppose I'm asking if folks this would be worth the effort? > > > > > > > > > Best wishes, > > > > > > > > > Drew > > > > > > > > > On Sun, Jan 13, 2019 at 10:29 PM Drew Jensen > > > > > > > > > drewjensen.in...@gmail.com > > > > > > > > > > > > > > > > wrote: > > > > > > > > > > > > > > > > > > > Howdy, > > > > > > > > > > What you think about something to highlight the work going > > > > > > > > > > into speeding > > > > > > > > > > > > > > > > > up Calc.. > > > > > > > > > > I was playing with some of the test files available in the > > > > > > > > > > source tree. > > > > > > > > > > > > > > > > > This particular file recalculates in half the time using LO > > > > > > > > > > 6.2 RC2 as > > > > > > > > > > > > > > > > > compared to 6.0.7 on the machine here. > > > > > > > > > > How to show that graphically, me thought. > > > > > > > > > > After a few minutes of fiddling came up this. > > > > > > > > > > https://youtu.be/FMSPMWGdNO0 > > > > > > > > > > Too rough to share? > > > > > > > > > > Drew > > > > > > > > > > > > > > -- > > > > > > > To unsubscribe e-mail to: > > > > > > > marketing+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/marketing/ > > > > > > > Privacy Policy: https://www.documentfoundation.org/privacy > > -- > > To unsubscribe e-mail to: marketing+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/marketing/ > Privacy Policy: https://www.documentfoundation.org/privacy -- To unsubscribe e-mail to: marketing+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/marketing/ Privacy Policy: https://www.documentfoundation.org/privacy