#5980: listSources in dbo_oracle.php
-----------------------------+----------------------------------------------
Reporter: shoebappa | Owner: phishy
Type: Optimization | Status: new
Priority: Medium | Milestone: 1.2.x.x
Component: Oracle | Version: 1.2 Final
Severity: Normal | Resolution:
Keywords: listSources | Php_version: n/a
Cake_version: |
-----------------------------+----------------------------------------------
Comment (by wilderland):
I found the problem in the souce code. The founded tables aren't cached. I
used a patch like this to solve it.
{{{
function listSources() {
$cache = parent::listSources();
if ($cache != null) {
return $cache;
}
$sql = 'SELECT view_name AS name FROM USER_views UNION SELECT table_name
AS name FROM USER_tables';
if (!$this->execute($sql)) {
return false;
}
$sources = array();
while($r = $this->fetchRow()) {
$sources[] = strtolower($r[0]['name']);
}
parent::listSources($sources);
return $sources;
}
}}}
In combination with USER_VIEWS and USER_TABLES it speed up to 1000%, maybe
you can include it to the next patch.
--
Ticket URL: <https://trac.cakephp.org/ticket/5980#comment:2>
CakePHP : The Rapid Development Framework for PHP <https://trac.cakephp.org/>
Cake is a rapid development framework for PHP which uses commonly known design
patterns like ActiveRecord, Association Data Mapping, Front Controller and MVC.
Our primary goal is to provide a structured framework that enables PHP users at
all levels to rapidly develop robust web applications, without any loss to
flexibility.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"tickets cakephp" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/tickets-cakephp?hl=en
-~----------~----~----~----~------~----~------~--~---
