<div dir="ltr"><br><div class="gmail_extra"><br><div class="gmail_quote">On Tue, Dec 2, 2014 at 4:36 PM, Matthias Wessendorf <span dir="ltr"><<a href="mailto:matzew@apache.org" target="_blank">matzew@apache.org</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex"><div dir="ltr"><div>Hi,</div><div><br></div><div>a few days ago I wrote a little test, that registers some installations in a concurrent fashion against a running UPS. Here is a polished version: <a href="https://gist.github.com/matzew/bb2c11bf55e2e5c7334d" target="_blank">https://gist.github.com/matzew/bb2c11bf55e2e5c7334d</a></div><div><br></div><div>The RESTful endpoints are behaving fine (they return 200) and deliver internally the tasks to a new thread, using our Async EJB. yay!</div><div><br></div><div>Of course, on different databases I noticed different results:</div><div><br></div><div>* POSTGRES</div><div>With Postgres I got reasonalbe/good results:</div><div>16 threads/1000 loops -> unit test took 50 seconds. (16k devices)</div><div>32 threads/1000 loops -> unit test took 120 seconds. (32k devices)</div><div><br></div><div>==> would be nice if we could improve this (e.g. with better JPQL or something like that)</div></div></blockquote><div>tracking this here:</div><div><a href="https://issues.jboss.org/browse/AGPUSH-1127">https://issues.jboss.org/browse/AGPUSH-1127</a><br></div><div><br></div><div>-M</div><div><br></div><div> </div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex"><div dir="ltr"><div><br></div><div><br></div><div>* H2 (WARNING - not a production database)</div><div>Writing to the H2 DB is (extremely) slow, regardless if in-memory or file-system :)</div><div>So, when the Unit test was done/finised, the writing to the (H2) database still goes on, for quite some time.</div><div>Using the H2 filesystem storage, I noticed some of these log messages -> <a href="https://gist.github.com/matzew/41635a254cbec9057e77" target="_blank">https://gist.github.com/matzew/41635a254cbec9057e77</a></div><div><br></div><div>Sure, it's H2 and we only use that during our development and test execution but I want at least mention the above behavior</div><div><br></div><div>* MYSQL</div><div>TBD</div><div><br></div><div>Oh, another thing I thought about, perhaps it would be possible to use (embedded) Postgress/MySQL during our tests with these guys:</div><div>* <a href="https://github.com/NessComputing/components-ness-pg" target="_blank">https://github.com/NessComputing/components-ness-pg</a></div><div>* mysql-connector-mxj</div><div><br></div><div><br></div><div>Any thoughts ? </div><span class=""><font color="#888888"><div>-Matthias</div><div><br></div>-- <br><div>Matthias Wessendorf <br><br>blog: <a href="http://matthiaswessendorf.wordpress.com/" target="_blank">http://matthiaswessendorf.wordpress.com/</a><br>sessions: <a href="http://www.slideshare.net/mwessendorf" target="_blank">http://www.slideshare.net/mwessendorf</a><br>twitter: <a href="http://twitter.com/mwessendorf" target="_blank">http://twitter.com/mwessendorf</a></div>
</font></span></div>
</blockquote></div><br><br clear="all"><div><br></div>-- <br><div class="gmail_signature">Matthias Wessendorf <br><br>blog: <a href="http://matthiaswessendorf.wordpress.com/" target="_blank">http://matthiaswessendorf.wordpress.com/</a><br>sessions: <a href="http://www.slideshare.net/mwessendorf" target="_blank">http://www.slideshare.net/mwessendorf</a><br>twitter: <a href="http://twitter.com/mwessendorf" target="_blank">http://twitter.com/mwessendorf</a></div>
</div></div>