<html><body><div style="color:#000; background-color:#fff; font-family:times new roman, new york, times, serif;font-size:16px">One more thing to check : could it be possible that your query is getting blocked because of lock escalation? Which isolation level are you using?<br><div><span></span></div><div> </div><div id="yui_3_16_0_1_1426003971828_20999"><div id="yui_3_16_0_1_1426003971828_20998">-----------------
<br>Benoit St-Jean
<br>Yahoo! Messenger: bstjean
<br>Twitter: @BenLeChialeux
<br>Pinterest: benoitstjean
<br>IRC: lamneth<br>
<br>Blogue: endormitoire.wordpress.com<br>
<br>"A standpoint is an intellectual horizon of radius zero". (A. Einstein)</div></div><br> <div id="yui_3_16_0_1_1426003971828_21072" style="font-family: times new roman, new york, times, serif; font-size: 16px;"> <div id="yui_3_16_0_1_1426003971828_21071" style="font-family: HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif; font-size: 16px;"> <div id="yui_3_16_0_1_1426003971828_21070" dir="ltr"> <hr id="yui_3_16_0_1_1426003971828_21069" size="1"> <font id="yui_3_16_0_1_1426003971828_21073" size="2" face="Arial"> <b><span style="font-weight:bold;">From:</span></b> Sebastian Sastre <sebastian@flowingconcept.com><br> <b><span style="font-weight: bold;">To:</span></b> Seaside - general discussion <seaside@lists.squeakfoundation.org> <br> <b><span style="font-weight: bold;">Sent:</span></b> Tuesday, March 10, 2015 11:57 AM<br> <b><span style="font-weight: bold;">Subject:</span></b> Re: [Seaside] Concurrent requests from multiple sessions<br> </font> </div> <div class="y_msg_container"><br><div id="yiv8547263252"><div><div class="yiv8547263252">Hi Ondrej,</div><div class="yiv8547263252"><br class="yiv8547263252" clear="none"></div><div class="yiv8547263252">are you using an ODBC connection? What comes to mind is to check if maybe the FFI call to ODBC or whatever driver you are using to get into DB2 is blocking the VM running that image until it gets the answer.</div><div class="yiv8547263252"><br class="yiv8547263252" clear="none"></div><div class="yiv8547263252">Whatever the case, you seem to need to scale your app horizonatally with many images.</div><div class="yiv8547263252"><br class="yiv8547263252" clear="none"></div><div class="yiv8547263252">At least that’s how I do it.</div><div class="yiv8547263252"><br class="yiv8547263252" clear="none"></div><div class="yiv8547263252">Other than that, there is something that you probably don’t want to even hear about but for what’s worth: a REST backend and a single page application scales really well due to clients’ CPU dividing load and RESTful backends having way better parallelisation</div><div class="yiv8547263252"><br class="yiv8547263252" clear="none"></div><div class="yiv8547263252">
<div class="yiv8547263252" style="color:rgb(0, 0, 0);letter-spacing:normal;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;word-wrap:break-word;"><div class="yiv8547263252" style="color:rgb(0, 0, 0);letter-spacing:normal;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;word-wrap:break-word;"><div class="yiv8547263252" style="color:rgb(0, 0, 0);letter-spacing:normal;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;word-wrap:break-word;"><div class="yiv8547263252" style="color:rgb(0, 0, 0);letter-spacing:normal;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;word-wrap:break-word;"><span class="yiv8547263252Apple-style-span" style="border-collapse:separate;color:rgb(0, 0, 0);font-family:Helvetica;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;orphans:2;text-indent:0px;text-transform:none;white-space:normal;widows:2;word-spacing:0px;border-spacing:0px;"></span><div class="yiv8547263252" style="word-wrap:break-word;"><span class="yiv8547263252Apple-style-span" style="border-collapse:separate;color:rgb(0, 0, 0);font-family:Helvetica;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;orphans:2;text-indent:0px;text-transform:none;white-space:normal;widows:2;word-spacing:0px;border-spacing:0px;"></span><div class="yiv8547263252" style="word-wrap:break-word;"><span class="yiv8547263252Apple-style-span" style="border-collapse:separate;color:rgb(0, 0, 0);font-family:Helvetica;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;orphans:2;text-indent:0px;text-transform:none;white-space:normal;widows:2;word-spacing:0px;border-spacing:0px;"></span><div class="yiv8547263252" style="word-wrap:break-word;"><div class="yiv8547263252"><div class="yiv8547263252"><a rel="nofollow" shape="rect" class="yiv8547263252" target="_blank" href="https://about.me/sebastianconcept">sebastian</a></div><div class="yiv8547263252"><br class="yiv8547263252" clear="none"></div><div class="yiv8547263252">o/</div></div><div class="yiv8547263252"><br class="yiv8547263252" clear="none"></div><div class="yiv8547263252">LinkedIn: <a rel="nofollow" shape="rect" class="yiv8547263252" target="_blank" href="http://www.linkedin.com/in/sebastiansastre">http://www.linkedin.com/in/sebastiansastre</a></div></div></div></div></div></div><div class="yiv8547263252" style="orphans:2;widows:2;"><span class="yiv8547263252" style="">github: </span><a rel="nofollow" shape="rect" class="yiv8547263252" target="_blank" href="https://github.com/sebastianconcept" style="">https://github.com/sebastianconcept</a></div><div class="yiv8547263252"><br class="yiv8547263252" clear="none"></div></div><br class="yiv8547263252Apple-interchange-newline" clear="none"></div><br class="yiv8547263252Apple-interchange-newline" clear="none"><br class="yiv8547263252Apple-interchange-newline" clear="none">
</div>
<br class="yiv8547263252" clear="none"><div class="qtdSeparateBR"><br><br></div><div class="yiv8547263252yqt6306257078" id="yiv8547263252yqt59382"><div><blockquote class="yiv8547263252" type="cite"><div class="yiv8547263252">On Mar 6, 2015, at 7:17 AM, wilwarin <<a rel="nofollow" shape="rect" class="yiv8547263252" ymailto="mailto:Ondrej.Altman@seznam.cz" target="_blank" href="mailto:Ondrej.Altman@seznam.cz">Ondrej.Altman@seznam.cz</a>> wrote:</div><br class="yiv8547263252Apple-interchange-newline" clear="none"><div class="yiv8547263252">Hi all,<br class="yiv8547263252" clear="none"><br class="yiv8547263252" clear="none">Currently we are developing a web application in Seaside, and it is<br class="yiv8547263252" clear="none">necessary for us to work in VAST. The application runs as a Windows service,<br class="yiv8547263252" clear="none">and for a few days we are facing the following issue:<br class="yiv8547263252" clear="none"><br class="yiv8547263252" clear="none">- At one moment there are two users (let's call them 'A' and 'B') logged in<br class="yiv8547263252" clear="none">in the application, so we have two different sessions.<br class="yiv8547263252" clear="none">- 'A' requests a page with a long list of objects obtained from DB2, so it<br class="yiv8547263252" clear="none">takes a number of seconds to get the results.<br class="yiv8547263252" clear="none">- Less than one second after 'A''s request, 'B' requests another page, for<br class="yiv8547263252" clear="none">instance an easy static page.<br class="yiv8547263252" clear="none">- For the time the 'A''s request is handled, the 'B''s browser window<br class="yiv8547263252" clear="none">freezes and waits for those number of seconds mentioned above.<br class="yiv8547263252" clear="none"><br class="yiv8547263252" clear="none">We searched really a lot, but still the results are not what we would<br class="yiv8547263252" clear="none">expect. This issue makes as confused, because in the future the application<br class="yiv8547263252" clear="none">should serve hundreds of users with very similar combinations of requests.<br class="yiv8547263252" clear="none"><br class="yiv8547263252" clear="none">We didn't know, where our problem lies, so we tried a similar test with a<br class="yiv8547263252" clear="none">single page with a difficult calculation inside. Then we tried the same in<br class="yiv8547263252" clear="none">Pharo to exclude the problem in VAST. Both with the same results.<br class="yiv8547263252" clear="none"><br class="yiv8547263252" clear="none">Is there anything we are missing? What should we do to achieve a parallel<br class="yiv8547263252" clear="none">(or kinda better) processing of requests?<br class="yiv8547263252" clear="none"><br class="yiv8547263252" clear="none">Thank you very much for your responses.<br class="yiv8547263252" clear="none"><br class="yiv8547263252" clear="none">Ondrej<br class="yiv8547263252" clear="none"><br class="yiv8547263252" clear="none"><br class="yiv8547263252" clear="none"><br class="yiv8547263252" clear="none">--<br class="yiv8547263252" clear="none">View this message in context: <a rel="nofollow" shape="rect" class="yiv8547263252" target="_blank" href="http://forum.world.st/Concurrent-requests-from-multiple-sessions-tp4809929.html">http://forum.world.st/Concurrent-requests-from-multiple-sessions-tp4809929.html</a><br class="yiv8547263252" clear="none">Sent from the Seaside General mailing list archive at <a rel="nofollow" shape="rect" class="yiv8547263252" target="_blank" href="http://nabble.com/">Nabble.com</a>.<br class="yiv8547263252" clear="none">_______________________________________________<br class="yiv8547263252" clear="none">seaside mailing list<br class="yiv8547263252" clear="none"><a rel="nofollow" shape="rect" class="yiv8547263252" ymailto="mailto:seaside@lists.squeakfoundation.org" target="_blank" href="mailto:seaside@lists.squeakfoundation.org">seaside@lists.squeakfoundation.org</a><br class="yiv8547263252" clear="none">http://lists.squeakfoundation.org/cgi-bin/mailman/listinfo/seaside<br class="yiv8547263252" clear="none"></div></blockquote></div></div><br class="yiv8547263252" clear="none"></div></div><br><div class="yqt6306257078" id="yqt48356">_______________________________________________<br clear="none">seaside mailing list<br clear="none"><a shape="rect" ymailto="mailto:seaside@lists.squeakfoundation.org" href="mailto:seaside@lists.squeakfoundation.org">seaside@lists.squeakfoundation.org</a><br clear="none"><a shape="rect" href="http://lists.squeakfoundation.org/cgi-bin/mailman/listinfo/seaside" target="_blank">http://lists.squeakfoundation.org/cgi-bin/mailman/listinfo/seaside</a><br clear="none"></div><br><br></div> </div> </div> </div></body></html>