r58165 MediaWiki - Code Review archive

Repository:MediaWiki
Revision:r58164‎ | r58165 | r58166 >
Date:22:05, 26 October 2009
Author:kipcool
Status:deferred
Tags:
Comment:
faster sql query
Modified paths:
  • /trunk/extensions/Wikidata/util/stats.php (modified) (history)

Diff [purge]

Index: trunk/extensions/Wikidata/util/stats.php
@@ -39,7 +39,7 @@
4040 $expressions_a = mysql_fetch_row( $expressions_r );
4141 $expressions = $expressions_a[0];
4242
43 -$defined_meanings_r = mysql_query( "SELECT COUNT(DISTINCT uw_syntrans.defined_meaning_id) FROM uw_syntrans, uw_expression WHERE uw_syntrans.remove_transaction_id IS NULL AND uw_expression.remove_transaction_id IS NULL AND uw_syntrans.expression_id = uw_expression.expression_id" );
 43+$defined_meanings_r = mysql_query( "SELECT COUNT(DISTINCT defined_meaning_id) FROM uw_syntrans WHERE remove_transaction_id IS NULL" );
4444 $defined_meanings_a = mysql_fetch_row( $defined_meanings_r );
4545 $defined_meanings = $defined_meanings_a[0];
4646 echo"<br />\n";

Status & tagging log