Sample Header Ad - 728x90

Why is the schema/structure dump so slow?

1 vote
1 answer
491 views
I'm using Rails 6 with activerecord-oracle_enhanced-adapter adapter for Oracle 11 XE database. At the beginning of the project I was working with Postgres, but due to customer requirements I had to migrate to Oracle. My question is very similar to https://stackoverflow.com/questions/592444/rails-rake-dbmigrate-very-slow-on-oracle , but it's from 11 years ago, i'm using the updated version of the adapter. I know that after all migrations are applied to database then rake db:migrate calls db:schema:dump task to generate schema.rb file from current database schema. I only have one schema, with many tables (around 90) The answer for the previous question was something like > One way how to debug this issue would be if you would put some debug > messages in oracle_enhanced_adapter.rb file so that you could identify > which method calls are taking so long time. == 20200820164111 RemoveSemesterFromProject: migrated (0.1347s) =============== real 13m26,038s user 0m5,494s sys 0m0,401s All migrations finished in an reasonable time, so I think the error occurs in the following action "db: schema: dump" but i don't have oracle_enchaced_adapter.rb neither oracle_enhanced_adapter.rb, so i don't know where to look at. What can i do for improve this behaviour? Time that takes when i run db:schema:dump
real	9m44,074s
user	0m3,701s
sys	0m0,327s
and this is the time that takes when i run db:structure:dump
real	21m40,073s
user	0m5,046s
sys	0m0,413s
Asked by Grizz (11 rep)
Aug 25, 2020, 04:07 PM
Last activity: Aug 9, 2021, 09:02 PM