Ruby on Rails | Screencasts | Download | Documentation | Weblog | Community | Source

Ticket #10331 (closed enhancement: invalid)

Opened 2 years ago

Last modified 2 years ago

Change OracleAdapter#indexes SQL query to run more quickly

Reported by: lisa Assigned to: core
Priority: normal Milestone: 2.x
Component: ActiveRecord Version: edge
Severity: normal Keywords: oracle, activerecord
Cc:

Description

The existing SQL query as of source:/adapters/oracle/lib/active_record/connection_adapters/oracle_adapter.rb#8246 is very slow when the Oracle server has many databaases and indexes. The proposed query runs much more quickly (in one case from 45 seconds per table to 2 seconds per table).

The patch is attached.

Attachments

change_oracleadapter_indexes_to_run_quicker.diff (1.4 kB) - added by lisa on 12/01/07 20:45:21.
Patch to increase speed of OracleAdapter#indexes SQL

Change History

12/01/07 20:45:21 changed by lisa

  • attachment change_oracleadapter_indexes_to_run_quicker.diff added.

Patch to increase speed of OracleAdapter#indexes SQL

12/03/07 21:50:19 changed by lisa

  • status changed from new to closed.
  • resolution set to invalid.

Will forward this to the adapter's maintainer.