[Interchange-bugs] [Bug 227] New - Enhancement to make Vend::Table::DBI::list_fields more efficient with Oracle
bugzilla-daemon@interchange.redhat.com
bugzilla-daemon@interchange.redhat.com
Wed Jun 20 10:27:00 2001
http://developer.akopia.com/bugs/show_bug.cgi?id=227
*** shadow/227 Wed Jun 20 10:26:39 2001
--- shadow/227.tmp.13409 Wed Jun 20 10:26:39 2001
***************
*** 0 ****
--- 1,25 ----
+ Bug#: 227
+ Product: Interchange
+ Version: 4.7.x
+ Platform: Other
+ OS/Version: other
+ Status: NEW
+ Resolution:
+ Severity: enhancement
+ Priority: P5
+ Component: Core
+ AssignedTo: mike@minivend.com
+ ReportedBy: matt@boltbluecorp.com
+ URL:
+ Cc:
+ Summary: Enhancement to make Vend::Table::DBI::list_fields more efficient with Oracle
+
+ Vend::Table::DBI::list_fields is pretty inefficient when it can't limit the
+ number of rows in the SQL statement. Even if it is not necessary to fetch in
+ order to get the field names, the prepare will take forever if you've got a
+ large number of rows.
+
+ With this in mind, I've hacked a solution for Oracle that is more efficient by
+ simply querying the column_name and data_type fields from the built-in table
+ user_tab_columns. Here is a patch to DBI.pm that works with my implementation,
+ although it has not been rigorously tested.