An important key in every allwiki-iteration is imho the re-use of
connections.
In php this is quite easy actually.
$connections = array();
$connections['1'] = mysql_connect( ... );
$connections['2'] = mysql_connect( ... );
etc.
then, when you're going to query toolserver.wiki sql db table, in the
loop
that follows afterwards, something like
foreach ( $rows as $row ) {
$currentSqlCon = isset( $connections[ $row->server ] ) ?
$connections[ $row->server ] : false;
if ( $currentSqlCon ) [
$query = mysql_query( $my_query, $currentSqlCon );
....
}
That way you won't have to make 100s of connections.
From what I remember both Luxo's, vvv's and my own do it like this
for global
tools.
Ofcourse you can always look at own source code in svn and/or my looking
at our php files directly from your toolserver account.
--
Krinkle
_______________________________________________
Toolserver-l mailing list (Toolserver-l@lists.wikimedia.org)
https://lists.wikimedia.org/mailman/listinfo/toolserver-l
Posting guidelines for this list:
https://wiki.toolserver.org/view/Mailing_list_etiquette
