Difference between #2 and #3 of
Increasing AR performance in connections with Oracle

Revision #3 has been created by ArmG on Sep 17, 2011, 4:08:24 PM with the memo:

$table->foreignKeys[$name]=array($row["TABLE_REF"], array($row["COLUMN_REF"])); -> $table->foreignKeys[$name]=array($row["TABLE_REF"], $row["COLUMN_REF"]);
« previous (#2) next (#4) »

Changes

Title unchanged

Incresing AR performance in connections with Oracle

Category unchanged

How-tos

Yii version unchanged

Tags unchanged

AR, active record, performance, speedup

Content changed

[...]
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;
}
}
[...]
1 0
15 followers
Viewed: 49 948 times
Version: 1.1
Category: How-tos
Tags: active record, AR, oracle, performance, speedup
Written by: Trejder
Last updated by: igorsantos07
Created on: Dec 14, 2010
Last updated: 12 years ago
Update Article
Revert to #2 | Revert to #3

Revisions

View all history