/** */
function convertLinks() {
+ global $wgDBtype;
+ if( $wgDBtype == 'PostgreSQL' ) {
+ print "Links table already ok on PostgreSQL.\n";
+ return;
+ }
+
print "Converting links table to ID-ID...\n";
global $wgLang, $wgDBserver, $wgDBadminuser, $wgDBadminpassword, $wgDBname;
performanceLog ( "Reading $numRows rows from cur table...\n" );
performanceLog ( "rows read vs seconds elapsed:\n" );
- $dbw->setBufferResults( false );
+ $dbw->bufferResults( false );
$res = $dbw->query( "SELECT cur_namespace,cur_title,cur_id FROM $cur" );
$ids = array();
}
}
$dbw->freeResult( $res );
- $dbw->setBufferResults( true );
+ $dbw->bufferResults( true );
print "Finished loading IDs.\n\n";
performanceLog( "Took " . (getMicroTime() - $baseTime) . " seconds to load IDs.\n\n" );
#--------------------------------------------------------------------
performanceLog( "rows inserted vs seconds elapsed:\n" );
for ($rowOffset = $initialRowOffset; $rowOffset < $numRows; $rowOffset += $linksConvInsertInterval) {
- $sqlRead = "SELECT * FROM $links ".wfLimitResult($linksConvInsertInterval,$rowOffset);
+ $sqlRead = "SELECT * FROM $links ".$dbw->limitResult($linksConvInsertInterval,$rowOffset);
$res = $dbw->query($sqlRead);
if ( $noKeys ) {
$sqlWrite = array("INSERT INTO $links_temp (l_from,l_to) VALUES ");