# Liquibase executes views

**URL:** https://forum.liquibase.org/t/liquibase-executes-views/553
**Category:** General Discussion
**Created:** [June 17, 2010, 11:55am UTC](https://forum.liquibase.org/t/liquibase-executes-views/553 "2010-06-17T11:55:00Z")
**Posts on this page:** 5
**Page:** 1

<div class="post-metadata">

### Author: ![ralscha](https://avatars.discourse-cdn.com/v4/letter/r/e68b1a/32.png) [@ralscha](https://forum.liquibase.org/u/ralscha)
#### Post date: [June 17, 2010, 11:55am UTC](https://forum.liquibase.org/t/liquibase-executes-views/553/1 "2010-06-17T11:55:00Z")

</div>

We use Liquibase in one of our projects and we have a little problem. The database contains a large number of views. Now everytime liquibase is working on a changeSet it calls every view. This takes about 1 hour. The database changes consists of 10 changeSet. To run this it will take about 10 hour. We use now a workaround that we delete the views before liquibase applies the changes and recreate the views after that. Is there something we can configure to prevent liquibase from executing every view.&nbsp; We use Version 1.9.1. Maybe this is something that is already changed in a newer version.

Thanks for your help  
Ralph

---

<div class="post-metadata">

### Author: ![nvoxland](https://avatars.discourse-cdn.com/v4/letter/n/87869e/32.png) [@nvoxland](https://forum.liquibase.org/u/nvoxland)
#### Post date: [June 17, 2010, 11:55am UTC](https://forum.liquibase.org/t/liquibase-executes-views/553/2 "2010-06-17T11:55:00Z")

</div>

I’m not sure why it would be executing the views.&nbsp; Are you using preconditions on your changeSets?&nbsp; If that is the case, we have made improvements for the upcoming 2.0 release that will help considerably.&nbsp; I’m not sure if the newer 1.9 releases will help, though.

Nathan

---

<div class="post-metadata">

### Author: ![ralscha](https://avatars.discourse-cdn.com/v4/letter/r/e68b1a/32.png) [@ralscha](https://forum.liquibase.org/u/ralscha)
#### Post date: [June 17, 2010, 11:55am UTC](https://forum.liquibase.org/t/liquibase-executes-views/553/3 "2010-06-17T11:55:00Z")

</div>

Yes we use preConditions. Here is a changeSet that executes every view in the database.

&nbsp;   
&nbsp; &nbsp;   
&nbsp; &nbsp; &nbsp;   
&nbsp; &nbsp;   
&nbsp; &nbsp;   
&nbsp;

I will try it with Liquibase 2 in the next few days and send some feedback how it works.

---

<div class="post-metadata">

### Author: ![ralscha](https://avatars.discourse-cdn.com/v4/letter/r/e68b1a/32.png) [@ralscha](https://forum.liquibase.org/u/ralscha)
#### Post date: [June 17, 2010, 11:55am UTC](https://forum.liquibase.org/t/liquibase-executes-views/553/4 "2010-06-17T11:55:00Z")

</div>

The problem is solved. I had to update to Liquibase 1.9.5. I thought we are already using the latest version but we had version 1.9.1 in our classpath. 1.9.5 will no longer execute the views and the update of the database only takes a few seconds.

Sorry for the post.

Ralph

---

<div class="post-metadata">

### Author: ![nvoxland](https://avatars.discourse-cdn.com/v4/letter/n/87869e/32.png) [@nvoxland](https://forum.liquibase.org/u/nvoxland)
#### Post date: [June 17, 2010, 11:55am UTC](https://forum.liquibase.org/t/liquibase-executes-views/553/5 "2010-06-17T11:55:00Z")

</div>

Glad you figured it out.&nbsp; Sorry I didn’t remember that bug fix between 1.9.1 and 1.9.5

Nathan