[Interchange-bugs] [Bug 227] New - Enhancement to make Vend::Table::DBI::list_fields more efficient with Oracle

[bugzilla-daemon@interchange.redhat.com]

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.