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

[Petr Bena]

Also, it would help to tell us what your script uses:

db?
filesystem?
cpu?
memory?
remote api?

On Sun, May 5, 2013 at 11:08 AM, Petr Bena <benapetr at gmail.com> wrote:
> 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