# Stardog performance issue in Stardog 7

**URL:** <https://community.stardog.com/t/stardog-performance-issue-in-stardog-7/1844>\
**Category:** Bug\
**Created:** [August 22, 2019, 1:33pm UTC](https://community.stardog.com/t/stardog-performance-issue-in-stardog-7/1844 "2019-08-22T13:33:11Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![serge](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.stardog.com/serge/32/376_2.png) [@serge](https://community.stardog.com/u/serge)\
**Post date:** [August 22, 2019, 1:33pm UTC](https://community.stardog.com/t/stardog-performance-issue-in-stardog-7/1844/1 "2019-08-22T13:33:11Z")

</div>

FYI - This query take around 2.6s in the latest 6 however it timeout (\>300 seconds) in version 7

```
INSERT {
   ?x0 <tag:stardog:api:obf:2d8223823236159503009746d91e3a94c632c33ea46603b1ff00f31ea5969368> ?x1 .
}
WHERE {
   {
      SELECT *
      WHERE {
         {
            {
               {
                  ?x2 <tag:stardog:api:obf:522681ebd322bd3b24accf17f84c2586491e23de989ba17f997c1a45579ab5a4> ?x3 .
                  ?x2 a <tag:stardog:api:obf:231cc7a7bba3c6ec884dbc48a0be75e5ebe1641a684335812e02a7aaa448de96> .
                  ?x3 a <tag:stardog:api:obf:231cc7a7bba3c6ec884dbc48a0be75e5ebe1641a684335812e02a7aaa448de96> .
                  ?x1 <tag:stardog:api:obf:2d8223823236159503009746d91e3a94c632c33ea46603b1ff00f31ea5969368> ?x2 .
                  ?x3 <tag:stardog:api:obf:2d8223823236159503009746d91e3a94c632c33ea46603b1ff00f31ea5969368> ?x0 .
                  ?x4 <tag:stardog:api:obf:5480bfa29b9d016dfdee42210d2613fec31945b2521b1c4caeacf874771c4639>+ ?x0 .
                  ?x4 <tag:stardog:api:obf:5480bfa29b9d016dfdee42210d2613fec31945b2521b1c4caeacf874771c4639>+ ?x1 .
                  ?x4 a <tag:stardog:api:obf:7004846bc599315934eff46d8f7711adf634264b769c44d2052700e0a5aa6bba> .
               }
            }
            UNION
            {
               {
                  {
                     ?x3 <tag:stardog:api:obf:522681ebd322bd3b24accf17f84c2586491e23de989ba17f997c1a45579ab5a4> ?x2 .
                     ?x2 a <tag:stardog:api:obf:231cc7a7bba3c6ec884dbc48a0be75e5ebe1641a684335812e02a7aaa448de96> .
                     ?x3 a <tag:stardog:api:obf:231cc7a7bba3c6ec884dbc48a0be75e5ebe1641a684335812e02a7aaa448de96> .
                     ?x1 <tag:stardog:api:obf:2d8223823236159503009746d91e3a94c632c33ea46603b1ff00f31ea5969368> ?x2 .
                     ?x0 <tag:stardog:api:obf:2d8223823236159503009746d91e3a94c632c33ea46603b1ff00f31ea5969368> ?x3 .
                     ?x4 <tag:stardog:api:obf:5480bfa29b9d016dfdee42210d2613fec31945b2521b1c4caeacf874771c4639>+ ?x1 .
                     ?x4 <tag:stardog:api:obf:5480bfa29b9d016dfdee42210d2613fec31945b2521b1c4caeacf874771c4639>+ ?x0 .
                     ?x4 a <tag:stardog:api:obf:7004846bc599315934eff46d8f7711adf634264b769c44d2052700e0a5aa6bba> .
                  }
               }
               UNION
               {
                  {
                     {
                        ?x3 <tag:stardog:api:obf:522681ebd322bd3b24accf17f84c2586491e23de989ba17f997c1a45579ab5a4> ?x2 .
                        ?x2 a <tag:stardog:api:obf:231cc7a7bba3c6ec884dbc48a0be75e5ebe1641a684335812e02a7aaa448de96> .
                        ?x3 a <tag:stardog:api:obf:231cc7a7bba3c6ec884dbc48a0be75e5ebe1641a684335812e02a7aaa448de96> .
                        ?x2 <tag:stardog:api:obf:2cd2b0148634ae8808456e839b0061686421f769385aa5fe457f31c7f5f193db> ?x0 .
                        ?x1 <tag:stardog:api:obf:2d8223823236159503009746d91e3a94c632c33ea46603b1ff00f31ea5969368> ?x3 .
                        ?x4 <tag:stardog:api:obf:5480bfa29b9d016dfdee42210d2613fec31945b2521b1c4caeacf874771c4639>+ ?x1 .
                        ?x4 <tag:stardog:api:obf:5480bfa29b9d016dfdee42210d2613fec31945b2521b1c4caeacf874771c4639>+ ?x0 .
                        ?x4 a <tag:stardog:api:obf:7004846bc599315934eff46d8f7711adf634264b769c44d2052700e0a5aa6bba> .
                     }
                  }
                  UNION
                  {
                     {
                        {
                           ?x3 <tag:stardog:api:obf:522681ebd322bd3b24accf17f84c2586491e23de989ba17f997c1a45579ab5a4> ?x2 .
                           ?x2 a <tag:stardog:api:obf:231cc7a7bba3c6ec884dbc48a0be75e5ebe1641a684335812e02a7aaa448de96> .
                           ?x3 a <tag:stardog:api:obf:231cc7a7bba3c6ec884dbc48a0be75e5ebe1641a684335812e02a7aaa448de96> .
                           ?x1 <tag:stardog:api:obf:2d8223823236159503009746d91e3a94c632c33ea46603b1ff00f31ea5969368> ?x2 .
                           ?x3 <tag:stardog:api:obf:2d8223823236159503009746d91e3a94c632c33ea46603b1ff00f31ea5969368> ?x0 .
                           ?x4 <tag:stardog:api:obf:5480bfa29b9d016dfdee42210d2613fec31945b2521b1c4caeacf874771c4639>+ ?x1 .
                           ?x4 <tag:stardog:api:obf:5480bfa29b9d016dfdee42210d2613fec31945b2521b1c4caeacf874771c4639>+ ?x0 .
                           ?x4 a <tag:stardog:api:obf:7004846bc599315934eff46d8f7711adf634264b769c44d2052700e0a5aa6bba> .
                        }
                     }
                     UNION
                     {
                        {
                           ?x3 <tag:stardog:api:obf:522681ebd322bd3b24accf17f84c2586491e23de989ba17f997c1a45579ab5a4> ?x2 .
                           ?x2 a <tag:stardog:api:obf:231cc7a7bba3c6ec884dbc48a0be75e5ebe1641a684335812e02a7aaa448de96> .
                           ?x3 a <tag:stardog:api:obf:231cc7a7bba3c6ec884dbc48a0be75e5ebe1641a684335812e02a7aaa448de96> .
                           ?x1 <tag:stardog:api:obf:2d8223823236159503009746d91e3a94c632c33ea46603b1ff00f31ea5969368> ?x2 .
                           ?x3 <tag:stardog:api:obf:2cd2b0148634ae8808456e839b0061686421f769385aa5fe457f31c7f5f193db> ?x0 .
                           ?x4 <tag:stardog:api:obf:5480bfa29b9d016dfdee42210d2613fec31945b2521b1c4caeacf874771c4639>+ ?x1 .
                           ?x4 <tag:stardog:api:obf:5480bfa29b9d016dfdee42210d2613fec31945b2521b1c4caeacf874771c4639>+ ?x0 .
                           ?x4 a <tag:stardog:api:obf:7004846bc599315934eff46d8f7711adf634264b769c44d2052700e0a5aa6bba> .
                        }
                     }
                  }
               }
            }
         }
         MINUS {
            ?x0 <tag:stardog:api:obf:2d8223823236159503009746d91e3a94c632c33ea46603b1ff00f31ea5969368> ?x1 .
         }
      }
   }
}

```

Dataset to large to publish here.

---

<div class="post-metadata">

**Author:** ![stephen](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.stardog.com/stephen/32/27_2.png) [@stephen](https://community.stardog.com/u/stephen)\
**Post date:** [August 22, 2019, 1:52pm UTC](https://community.stardog.com/t/stardog-performance-issue-in-stardog-7/1844/2 "2019-08-22T13:52:39Z")

</div>

Hi Serge,

Could you post the query plans generated by both 6.2.3 and 7.0.0?

---

<div class="post-metadata">

**Author:** ![serge](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.stardog.com/serge/32/376_2.png) [@serge](https://community.stardog.com/u/serge)\
**Post date:** [August 22, 2019, 1:54pm UTC](https://community.stardog.com/t/stardog-performance-issue-in-stardog-7/1844/3 "2019-08-22T13:54:43Z")

</div>

my license for 6.2.3 has expired, hence the reason I install 7 🙂