[Labs-l] Performance at tool-labs compared with TS

[Petr Bena]

Hi, could you do similar test on bots project? That is supposed to be
a staging area - so in future it will be tools beta version.

There are very much lower restrictions than on tools project, so we
might see if this problem is related to performance of VM or if that
is related to configuration. You don't need to even create a tool
account there, you just ssh, upload your tool and that is all. There
are no resource limits at all

On Sun, May 5, 2013 at 1:37 AM, Kolossos <tim.alder at s2002.tu-chemnitz.de> wrote:
> Hello,
> I move my templatetiger scripts as first tool from toolserver to labs. I
> compared performance of toolserver script[1] with that on labs[2]. To my
> suprise the labs script needs significant longer. So toolserver script needs
> 0.5 sec and labs script needs 5 sec. (Factor 10 !) If I increase the limit
> from 30 to 300 the toolserver script needs 2 seconds, on labs it need
> unacceptable 48 sec.
>
> So something is going wrong.
>
> I test a php script with a simple but long for-next-loop, both servers react
> similar, so php seem not be the problem.
> The queries directly on mysql-terminal are fast and seems not to be the
> problem. So perhaps the interface is the problem. Other reason could be that
> I work with SQL_CALC_FOUND_ROWS because Mysql had 2007 a bug with
> sub-queries, perhaps this makes now problems at maria.
>
> The php-script is simply a copy and I import the extracts of Alemannic to
> the database in the same way. To load at toollabs were with 0.2 relative
> low.
>
> What's the reason? Could somebody verify the behaviour I found.
>
> Greetings Tim alias Kolossos
>
> [1]http://toolserver.org/~kolossos/templatetiger/tt-table4.php?lang=alswiki&template=Gemeinde%20in%20Frankreich&where=&is=&&offset=240&limit=30
>
> [2]http://tools.wmflabs.org/templatetiger/tt-table4.php?lang=alswiki&template=Gemeinde%20in%20Frankreich&where=&is=&&offset=30&limit=30
>
>
> _______________________________________________
> Labs-l mailing list
> Labs-l at lists.wikimedia.org
> https://lists.wikimedia.org/mailman/listinfo/labs-l