Shemifier ensureIndexes problem with large oracle tables #1326

Closed
slavaschmidt opened this Issue Sep 20, 2012 · 2 comments

Comments

Projects
None yet
2 participants

There is a problem with large oracle tables (millions of records) while using Schemifier.
The reason for this is a usage of the value false for approximate parameter while calling [getIndexInfo](http://docs.oracle.com/javase/6/docs/api/java/sql/DatabaseMetaData.html#getIndexInfo(java.lang.String,%20java.lang.String,%20java.lang.String,%20boolean,%20boolean)
getIndexInfo(String catalog, String schema, String table, boolean unique, boolean approximate)
in ensureIndexes method (Schemifier.scala:292).
This causes oracle to execute analyze table TABLE compute statistics statement at the boot time. As a result, the application needs much time to start (one hour in my configuration). At this time web container is locked waiting for oracle.

It would be nice to have some possibility to change the value of the `àpproximate``parameter.

Thank you.

Owner

dpp commented Sep 20, 2012

Please discuss issues on the Lift mailing list before opening tickets. Please see http://www.liftweb.net/community for more info.

@dpp dpp closed this Sep 20, 2012

Thank you very much for looking into this.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment