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

Ticket #11519 (new enhancement)

Opened 1 month ago

[PATCH] Improve rake db:schema:dump performance in ActiveRecord Oracle adapter

Reported by: raymonds Assigned to: schoenm@earthlink.net
Priority: normal Milestone: 2.x
Component: ActiveRecord Version: 2.0.1
Severity: normal Keywords:
Cc:

Description

If Rails schema is installed Oracle database with many other schemas with many other tables and other database objects then rake db:schema:dump task is very slow due to some selects from user_% and all_% data dictionary tables.

This patch modifies these select statements so that they perform much better on large data dictionaries. Testing was done on Oracle database with 22000 tables which are located in different schemas.

Attachments

schema_dump_performance_improvements.diff (2.4 kB) - added by raymonds on 04/03/08 16:40:05.

Change History

04/03/08 16:40:05 changed by raymonds

  • attachment schema_dump_performance_improvements.diff added.