# How ICV impact performance?

**URL:** <https://community.stardog.com/t/how-icv-impact-performance/2608>\
**Category:** Support\
**Created:** [July 23, 2020, 3:10am UTC](https://community.stardog.com/t/how-icv-impact-performance/2608 "2020-07-23T03:10:16Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![crapthings](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.stardog.com/crapthings/32/686_2.png) [@crapthings](https://community.stardog.com/u/crapthings)\
**Post date:** [July 23, 2020, 3:10am UTC](https://community.stardog.com/t/how-icv-impact-performance/2608/1 "2020-07-23T03:10:17Z")

</div>

i've found my query is kinda slow after enable icv.  
is this normal behavior?

---

<div class="post-metadata">

**Author:** ![zachary.whitley](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.stardog.com/zachary.whitley/32/94_2.png) [@zachary.whitley](https://community.stardog.com/u/zachary.whitley)\
**Post date:** [July 24, 2020, 11:48am UTC](https://community.stardog.com/t/how-icv-impact-performance/2608/2 "2020-07-24T11:48:11Z")

</div>

You can expect a performance penalty for update queries as Stardog will execute additional queries as part of verifying constraints. How much will depend on how much data you have, type and number of constraints. If you feel that it’s excessive you can submit a report similar to how you might report a slow query.

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex030/uploads/stardog/original/2X/e/ed66b48a616f505106a4acde3c9cee7e6da9bc67.svg) [@system](https://community.stardog.com/u/system)\
**Post date:** [August 7, 2020, 11:48am UTC](https://community.stardog.com/t/how-icv-impact-performance/2608/3 "2020-08-07T11:48:12Z")

</div>

This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.