Apache OpenOffice (AOO) Bugzilla – Issue 59724
$eis->getCWSWithState() is too slow
Last modified: 2013-08-07 15:34:52 UTC
$ time ./eis-test.pl CWS list [SRC680] : mtg1 memory02 encupfix01 cmcfixes22 stlpdbg iconswitching1 waratahbasctl gcnolk impresspresobjs cloph02 perform07 os67 epspreview hunspell sysui12 dmake43p01 dba202c hr17 locales202 impress78 britishthesau sb44 macosxfondu fs05 qpro03 dbo510 pbrwuno cairocanvas vcl49 optstor2 real 1m28.391s user 0m0.265s sys 0m0.000s The script (find attached) just gets the 'ready for QA' CWSs. Is there a possibility to speed this up? (Something similar is used to set the valid tinderbox tags on go-oo.org)
Created attachment 32676 [details] Script to get a list of CWS modules in a certain state
@bei: The OOo EIS server is indeed way slower in doing a getCWSWithState() call than the Hamburg internal EIS server (6s wall clock vs 42s wall clock in my measurements). Can you have a look at this? @vq: You are aware of 'cwsquery ready'? Some timings: Hamburg internal server: time cwsquery ready cwsquery -- version: 1.8 cwsquery: Master workspace 'SRC680': cwsquery: CWSs ready for QA: mtg1 memory02 encupfix01 cmcfixes22 stlpdbg vq25 iconswitching1 waratahbasctl gcnolk impresspresobjs cloph02 perform07 os67 epspreview hunspell sysui12 dmake43p01 hr17 dba202c locales202 os72 impress78 macosxfondu sb44 britishthesau fs05 qpro03 dbo510 pbrwuno jl29jre cairocanvas vcl49 optstor2 0.371u 0.054s 0:05.74 7.3% 0+0k 0+0io 827pf+0w OOo server: time cwsquery ready cwsquery -- version: 1.8 cwsquery: Master workspace 'SRC680': cwsquery: CWSs ready for QA: mtg1 memory02 encupfix01 cmcfixes22 stlpdbg vq25 iconswitching1 waratahbasctl gcnolk impresspresobjs cloph02 perform07 os67 epspreview hunspell sysui12 dmake43p01 hr17 locales202 dba202c impress78 os72 sb44 britishthesau macosxfondu fs05 qpro03 dbo510 pbrwuno cairocanvas vcl49 optstor2 0.414u 0.055s 0:42.49 1.0% 0+0k 0+0io 757pf+0w
*** Issue 59726 has been marked as a duplicate of this issue. ***
bei->vq,hr: accepted. The first additional costs I can think of involved when using eis.services.openoffice.org vs local eis in Hamburg are the following: 1.) On an external connection HTTPS is used while the internal server is unsecured 2.) On an external connection HTTP Authentication is used, which means some additional roundtrips back and forth to the server for the authentication handshake while the internal server is unsecured 3.) An intranet connection is of course slower than a connection via the local network I will look into what else might make things slower. I am not sure wether dropping HTTPS and HTTP Authentication and thus introducing more security risks would be a good idea. For the tag list http://go-oo.org/tinderbox/tags/tag-list mentionend in Issue 59726 which takes so long to be generated I think one problem is that lot´s of SOAP calls are needed to generate the complete list - a possible solution might be to offer an additional method on the server to generate the whole list with just one SOAP call.
jj->bei: Please do not switch to HTTPS as this would mean that the passwords would be transferred unencrypted over the network.
jj->vq: After some modifications to the network settings of the webserver, the services offered seem to be way faster than before. Could you please check whether the performance is now acceptable for you. Thx
$ time ~/eis-test.pl CWS list [SRC680] : mtg1 memory02 encupfix01 cmcfixes22 stlpdbg vq25 waratahbasctl gcnolk cloph02 perform07 epspreview sb41 hunspell sysui12 dba202b configure13 native34 dmake43p01 hr17 impress78 britishthesau macosxfondu fs05 dbo510 qpro03 pbrwuno jl29jre cairocanvas vcl49 optstor2 real 0m2.046s user 0m0.468s sys 0m0.140s That looks good to me!
OK
was verified by vq, closing issue
Created attachment 74101