Re: [libreoffice-marketing] Re: It's Sunday night - lets fiddle with Calc Threading...
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 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 gu
Re: [libreoffice-marketing] Re: It's Sunday night - lets fiddle with Calc Threading...
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
Re: [libreoffice-marketing] Re: It's Sunday night - lets fiddle with Calc Threading...
Howdy > > Looks great; we use only real-cores to calculate on[1]; so I'd > mention > 2 cores - rather than 4 threads. As such we got ~2x as fast with 2 cores > ;-) > > Do you have a 4 core machine nearby - or better a 24 one ? > Thought I did. My test machine for this is described as: Processor: AMD A10-5800k apu with radeon hd graphics x4 Memory: 7 GiB Graphics: AMD Aruba OS; Ubuntu 18.04.1 LTS OS type: 64 bit Gnome: 3.28.2 Disk: 308 GB The files used came from a source patch referring to benchmarking OpenCL functionality and includes 5 spreadsheets (xls all). Included is a python script to run them as a batch and to write out recalc times. So, if I understand correctly OpenCL doesn't mean much on this Linux desktop, but I will be able to try, a little later, on a Windows 10 machine also so I took that this would however still show the multi-corps threading support. I went back and reran the batch with as little else (easily possible) running on the test machine. Performance increase varied based on the file, ranging from ~76% - 30% Stock History 6.0.7 : 13.9 sec 6.2.0 : 8.71 sec 62.68% 37.32% performance increase Stocks Price Time Correlation 6.0.7 : 21.38 sec 6.2.0 : 9.57 sec 44.79% 55.31% performance increase Energy Market 6.0.7 : 28.44 sec 6.2.0 : 12.43 sec 43.74% 58.36% performance increase Ground Water Daily 6.0.7 : 92.52 sec 6.2.0 : 32.38 sec 35.00% 65.00% performance increase Gross Profit Supermarkets 6.0.7 : 66.95 sec 6.2.0 : 20.15 sec 30.09% 69.91% performance increase Building Design 6.0.7 : 50.14 sec 6.2.0 : 12.06 sec 24.05% 75.95% performance increase The files each contain a write up as to what the data represents and what statistical functions are being exercised. More (on other follow up email) on these as this we go. Best wishes, Drew > > Lovely video though; I love the raw motorbike-with-hole-in-exhaust > ricer feel =) > > Good stuff, > > Michael. > > [1] - hyper-threading is not our friend in the case of some heavy usage > and can make it slower ;-) > -- > michael.me...@collabora.com <><, GM Collabora Productivity > Hangout: mejme...@gmail.com, Skype: mmeeks > (M) +44 7795 666 147 - timezone usually UK / Europe > -- 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
Re: [libreoffice-marketing] Re: It's Sunday night - lets fiddle with Calc Threading...
Drew Jensen wrote on 1/14/19 5:37 AM: > Sorry, lets try that URL again for the second file > https://youtu.be/ED-zipIV1dE Really appreciate it Drew. Nice to mix music, views info. I've nothing to add to what others suggested, so I Look forward to spread it :) Cheers, Cor -- Cor Nouws GPD key ID: 0xB13480A6 - 591A 30A7 36A0 CE3C 3D28 A038 E49D 7365 B134 80A6 - vrijwilliger https://nl.libreoffice.org - volunteer https://www.libreoffice.org - Member Board The Document Foundation - http://www.nouenoff.nl / https://www.mijncloudoffice.nl -- 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
Re: [libreoffice-marketing] Re: It's Sunday night - lets fiddle with Calc Threading...
Hi Drew, On 14/01/2019 06:40, Drew Jensen 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. Nice =) > What do you think? Looks great; we use only real-cores to calculate on[1]; so I'd mention 2 cores - rather than 4 threads. As such we got ~2x as fast with 2 cores ;-) Do you have a 4 core machine nearby - or better a 24 one ? Lovely video though; I love the raw motorbike-with-hole-in-exhaust ricer feel =) Good stuff, Michael. [1] - hyper-threading is not our friend in the case of some heavy usage and can make it slower ;-) -- michael.me...@collabora.com <><, GM Collabora Productivity Hangout: mejme...@gmail.com, Skype: mmeeks (M) +44 7795 666 147 - timezone usually UK / Europe -- 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
Re: [libreoffice-marketing] Re: It's Sunday night - lets fiddle with Calc Threading...
Hi Drew, On 14/01/2019 07:40, Drew Jensen wrote: > > So a real first draft, I put the two runs one after so the run length went > to 1:13 > https://youtu.be/_jtmydRYSoU This is great -- thanks for creating it! Videos like these are really useful to show under-the-hood improvements in LibreOffice in a more understandable way. > The sound track is not quite right, some popping with the car engine mix, > but you get the idea. Yeah, the popping is an issue, but I like the idea with the engine. My two suggesions would be: 1) A bit of info at the start, providing some context -- eg "LibreOffice 6.2 includes calculation threading, which boosts performance". Followed by: "Let's see it in action, on a complicated spreadsheet" (I don't think you need to mention that it's about energy markets in different countries -- that's just extra info that could potentially confuse viewers, IMO) 2) At the end, a quick summary ("So LibreOffice 6.2 uses all CPU cores more effectively, for a big speed boost!"), and some crediting to the developer(s) and their affiliation as well. I can't find much about threading at https://wiki.documentfoundation.org/ReleaseNotes/6.2 though... So what do you think of those ideas? When we have a final video, I can spread it on Twitter, YouTube, Facebook, Reddit etc. :-) Mike -- 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
Re: [libreoffice-marketing] Re: It's Sunday night - lets fiddle with Calc Threading...
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. Sincerely, Sreekanth V K Sent with ProtonMail Secure Email. ‐‐‐ Original Message ‐‐‐ On Monday, January 14, 2019 12:10 PM, Drew Jensen 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
[libreoffice-marketing] Re: It's Sunday night - lets fiddle with Calc Threading...
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 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 > 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 >> 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
[libreoffice-marketing] Re: It's Sunday night - lets fiddle with Calc Threading...
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 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 > 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
[libreoffice-marketing] Re: It's Sunday night - lets fiddle with Calc Threading...
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 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