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