Increasing AR performance in connections with Oracle

Comparing #2 with #3

Revision #3 was created by ArmG ArmG on Sep 17, 2011, 4:08:24 PM.

$table->foreignKeys[$name]=array($row["TABLE_REF"], array($row["COLUMN_REF"])); -> $table->foreignKeys[$name]=array($row["TABLE_REF"], $row["COLUMN_REF"]);

Content

[...]
EOD;
$command=$this->getDbConnection()->createCommand($sql);
foreach($command->queryAll() as $row)
{
$name = $row["COLUMN_NAME"];
$table->foreignKeys[$name]=array($row["TABLE_REF"], array($row["COLUMN_REF"]));
if(isset($table->columns[$name]))
$table->columns[$name]->isForeignKey=true;
}
}
[...]