Stardog performance issue in Stardog 7

Support Bug
1

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.

2

Hi Serge,

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

3

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