#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 | Keywords: listSources
Php_version: n/a | Cake_version:
----------------------------+-----------------------------------------------
I noticed when trying to connect with Oracle, cake was painfully slow.
Fortunately the debug information showed the line in dbo_oracle.php for
list sources around line 447:
{{{
$sql = 'SELECT view_name AS name FROM all_views UNION SELECT table_name AS
name FROM all_tables';
}}}
Our environment has many thousands of table and views in use by other
users and this returns all of the table and view names that I assume are
on the same SID.
Changing this code to:
{{{
$sql = 'SELECT view_name AS name FROM user_views UNION SELECT table_name
AS name FROM user_tables';
}}}
Seemed to do the trick for me, but I'm just diving in, so I'm not sure
what else could break from that. It seems to me that showing what the
current user has access to makes sense, rather than listing everything.
--
Ticket URL: <https://trac.cakephp.org/ticket/5980>
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
-~----------~----~----~----~------~----~------~--~---
