A new topic, 'Column Exists Precondition is Slow', has been made on a board you are watching.
You can see it at
http://liquibase.org/forum/index.php?topic=98.new#newThe text of the topic is shown below:
The columnExists precondition takes about 5 seconds to run on our database. We have about 80 tables and 800+ columns.
Its building up the entire DatabaseSnapshot in a liquibase object before using the generic liquibase calls in each precondition.
I added a patch for mysql databases that does a sql call into the information_schema space. This takes milleseconds to run. (see attached).
Alternatively, the generated DatabaseSnapshot object could be cached until a database modification is done in a changeset, but I didn't see a quick way to do that.
The tableExists, foreignKeyExists, indexExists, viewExists, etc could stand to have a similar improvement.
(I haven't looked at the 2.0 branch yet to see if this overall problem is solved)
Unsubscribe to new topics from this board by clicking here:
http://liquibase.org/forum/index.php?action=notifyboard;board=2.0Regards,
The LiquiBase Community Forum Team.
------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now.
http://p.sf.net/sfu/bobj-july_______________________________________________
Liquibase-devel mailing list
Liquibase-devel@...
https://lists.sourceforge.net/lists/listinfo/liquibase-devel
